Hacker News Reader

Comment by zasdffaa | Hacker News Reader

No, SQL isd big an ugly. I wonder if it can do

    select ... (select ...) as some_alias, ...
    from ...

also, can't see SOME/ANY/ALL

View on HN

SQLGlot supports nested queries and EXISTS. SOME, ANY, and ALL aren't fully supported yet but it's only a couple lines to add support since I already support EXISTS.

https://github.com/tobymao/sqlglot/blob/main/tests/fixtures/... https://github.com/tobymao/sqlglot/blob/main/tests/fixtures/...

I'm impressed.

I've added support now for any, all, and some. Some is identical to Any so I always default to Any.

You can see what it took to add this in this commit.

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

Reply on news.ycombinator.com