No, SQL isd big an ugly. I wonder if it can do select ... (select ...) as some_a...

captaintobs · on July 5, 2022

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

zasdffaa · on July 5, 2022

I'm impressed.

captaintobs · on July 5, 2022

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