3 ms·
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
by zasdffaa 4y ago
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
- captaintobs 4y agoSQLGlot 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/identity.sql#L100 https://github.com/tobymao/sqlglot/blob/main/tests/fixtures/... https://github.com/tobymao/sqlglot/blob/main/tests/fixtures/identity.sql#L154 https://github.com/tobymao/sqlglot/blob/main/tests/fixtures/...
- zasdffaa 4y agoI'm impressed.
- captaintobs 4y agoI'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/ab49a3a2964bdff3a3423b4b3cb360987ce07da3 https://github.com/tobymao/sqlglot/commit/ab49a3a2964bdff3a3...