ekzhang/inline-sql

This is stars and forks stats for /ekzhang/inline-sql repository. As of 05 May, 2024 this repository has 404 stars and 8 forks.

Inline SQL A simple embedded language for running inline SQL in Python programs. from inline_sql import sql, sql_val assert sql_val^ "SELECT 1 + 1" == 2 x = 5 assert sql_val^ "SELECT $x * 2" == 10 df = sql^ "SELECT * FROM (VALUES (1, 10), (2, 20)) df (x, y)" assert sql_val^ "SELECT SUM(x) + SUM(y) FROM df" == 33 Operations in the inline_sql library run directly inside your process. You can query local datasets (pandas frames), CSV files, and even interpolate variables seamlessly. This is implemented...