Show HN: SQL-tString a t-string SQL builder in Python

Re:Show HN: SQL-tString a t-string SQL builder in Python by pgjones on Friday May 16, 2025 @10:35AM (#44006014)

Thanks, do you have a reference for SQL grammar - I've had no success finding an official source.

[ Parent | on HN ]

Re:Show HN: SQL-tString a t-string SQL builder in Python by schultzer on Friday May 16, 2025 @10:37AM (#44006035)

You can google SQL grammar. But here is the 2025: https://standards.iso.org/iso-iec/9075/-2/ed-6/en/

[ Parent | on HN ]

Re:Show HN: SQL-tString a t-string SQL builder in Python by pgjones on Friday May 16, 2025 @10:37AM (#44006044)

Thank you! My Google foo did not find this.

[ Parent | on HN ]

Re:Show HN: SQL-tString a t-string SQL builder in Python by UltraSane on Saturday May 17, 2025 @01:59PM (#44015912)

Google search sucks really bad now for very specific searches.

[ Parent | on HN ]

Re:Show HN: SQL-tString a t-string SQL builder in Python by westurner on Friday May 16, 2025 @01:27PM (#44007906)

Ibis has sqlglot for parsing and rewriting SQL query graphs; and there's sql-to-ibis: https://github.com/ibis-project/ibis/issues/9529

sqlglot: https://github.com/tobymao/sqlglot :

> SQLGlot is a no-dependency SQL parser, transpiler, optimizer, and engine [written in Python]. It can be used to format SQL or translate between 24 different dialects like DuckDB, Presto / Trino, Spark / Databricks, Snowflake, and BigQuery. It aims to read a wide variety of SQL inputs and output syntactically and semantically correct SQL in the targeted dialects.

[ Parent | on HN ]