3 ms·

The parser.py seems extremely terse, not a line of doc strings or typing. Perhaps that explains?

• 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 ago
    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/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 ago
      I'm impressed.
      • captaintobs 4y ago
        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/ab49a3a2964bdff3a3423b4b3cb360987ce07da3 https://github.com/tobymao/sqlglot/commit/ab49a3a2964bdff3a3...