News for hackers. Stuff that matters.

A comment on Writing Composable SQL Using Knex and Pipelines. Parent comment

Re:Writing Composable SQL Using Knex and Pipelines by MathMonkeyMan on Thursday November 28, 2024 @01:29PM (#42267510)
> In theory, you could parse the SQL and build up some kind of AST on which compatibility could be built.

This is an interesting problem that I'd like to learn more about. Have you read anything about it?

[ Parent | on HN ]
Re:Writing Composable SQL Using Knex and Pipelines by ajfriend on Thursday November 28, 2024 @02:02PM (#42267743)
You can compose SQL with https://ibis-project.org/tutorials/ibis-for-sql-users, which is using https://github.com/tobymao/sqlglot to parse the SQL under the hood.

As an alternative to parsing the SQL yourself, DuckDB's https://duckdb.org/docs/api/python/relational_api allows you to compose SQL expressions efficiently and lazily, which I've used when playing around with things like https://gist.github.com/ajfriend/eea0795546c7c44f1c24ab0560a...

[ Parent | on HN ]