Show HN: SQG – Compile SQL (SQLite,DuckDB) to TypeScript/Java Code (opens in new tab)

I developed SQG because I had to access a SQLite and a DuckDB database from Java and from Typescript and was unhappy about maintaining the DB access code twice.

Also for larger analytics queries (DuckDB) it was annoying to copy the query out of the code into DBeaver, work on it and then copy it back into the code.

So I thought of a way of keeping the SQL queries in a separate file, compatible in DBeaver format so I can run them there, and also generate the code from it.

This works especially well with DuckDB since it has full type information of the query result, better than SQLite which has it only for fields, not for expressions.

For DuckDB it can also generate code using their Apache Arrow API for very fast access.

I hope you find it useful, I am glad to hear your feedback.

GitHub: https://github.com/sqg-dev/sqg Docs: https://sqg.dev Try it online: https://sqg.dev/playground/