Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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


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...




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: