SQL Polyglot
Learning and science
sql database comparison
SHOW HN2023
SQL Polyglot
Try running a query anywhere from PostgreSQL to DuckDB without leaving your browser.
codapi.org53points
14comments
#1,039of 3,109 in 2023
Top 34%of 2023 by points
How HN took it
CuriousMostly questions and neutral comments
2 positive, 4 neutral or asking, 1 mixed, 0 critical, out of 7 comments about the project. Thread score +0.16.
Idea: 2 for, 0 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Useful for checking SQL feature support across databases
From 2 comments
Very cool. So many times I was wondering if database X supports particular SQL feature of function and if it works the same way. This makes it very easy to do
PeterZaitsev on HNYeah understood, the tool itself is cool. I think it will be something I keep bookmarked and check out when I’m working with a feature or sql syntax I’m not familiar with to see…
doesnt_know on HN
Objections
Cross-database standard SQL is hard in practice and loses database-specific features
From 2 comments
Cool idea, I've always wondered what it would look like to build a relatively large DB heavy stack where you use only standard SQL. I like the concept of being able to switch out…
doesnt_know on HNI've been recently toying around with dynamically switching between DuckDB and BigQuery on query time. So you have a layer of standard SQL in front, which uses sqlglot to…
astronautas on HN
C# playground times out
From 1 comment
Cool idea, I've always wondered what it would look like to build a relatively large DB heavy stack where you use only standard SQL. I like the concept of being able to switch out…
doesnt_know on HN
Requests
Increase the C# sandbox timeout
From 1 comment
SQL Polyglot is really more of an education/exploration thing. And yes, I should definitely increase the C# sandbox timeout. Will do :)
nalgeon on HN
Add syntax highlighting
From 1 comment
CodAPI looks like a nice tool to showcase code without getting into Jupyter/Colab. Syntax highlighting would be great to have.
d4rkp4ttern on HN
Questions
Is it built on sqlglot
From 1 comment
Cool! Is this built with sqlglot[1] on the back end? [1] https://github.com/tobymao/sqlglot
colinmilhaupt on HN
Alternatives named
sqlglot
From 2 comments
Cool! Is this built with sqlglot[1] on the back end? [1] https://github.com/tobymao/sqlglot
colinmilhaupt on HNI've been recently toying around with dynamically switching between DuckDB and BigQuery on query time. So you have a layer of standard SQL in front, which uses sqlglot to…
astronautas on HN
Substrait and Apache Arrow
From 1 comment
This is what Substrait and Apache Arrow seek to solve; but by serializing query plans that can be produced/consumed by different engines. It’s like an IR for sql.…
pjot on HN
Jupyter/Colab
From 1 comment
CodAPI looks like a nice tool to showcase code without getting into Jupyter/Colab. Syntax highlighting would be great to have.
d4rkp4ttern on HN