Port initial set of parser tests from `partiql-lang-kotlin`

[alancai98]

Port tests from partiql-lang-kotlin:

• SqlParserTests: https://github.com/partiql/partiql-lang-kotlin/blob/main/lang/test/org/partiql/lang/syntax/SqlParserTest.kt
• ParserErrorTests: https://github.com/partiql/partiql-lang-kotlin/blob/main/lang/test/org/partiql/lang/errors/ParserErrorsTest.kt
• Uncovered test categories from pts: https://github.com/partiql/partiql-lang-kotlin/tree/main/testscript/pts

[alancai98]

(following comment ported to a separate file. see partiql-lang-kotlin-omitted-tests.md)

From SqlParserTests.kt, will not currently import the following tests:

• Custom type cast -- not defined in spec
  • https://github.com/partiql/partiql-lang-kotlin/blob/34625c68dbcbaf7b8ae60df7a4cf65c60b2a3b79/lang/test/org/partiql/lang/syntax/SqlParserTest.kt#L631-L644
• Call date_add and date_diff (special syntax) -- not defined in spec or SQL92 spec
  • https://github.com/partiql/partiql-lang-kotlin/blob/34625c68dbcbaf7b8ae60df7a4cf65c60b2a3b79/lang/test/org/partiql/lang/syntax/SqlParserTest.kt#L957-L1036
• ORDER BY tests testing defaults for sort spec and null spec -- dependent on when parsed ast checking is added to assertions
  • https://github.com/partiql/partiql-lang-kotlin/blob/34625c68dbcbaf7b8ae60df7a4cf65c60b2a3b79/lang/test/org/partiql/lang/syntax/SqlParserTest.kt#L1793-L1888
• DML -- not defined in spec
  • https://github.com/partiql/partiql-lang-kotlin/blob/34625c68dbcbaf7b8ae60df7a4cf65c60b2a3b79/lang/test/org/partiql/lang/syntax/SqlParserTest.kt#L2129-L3855
• DDL -- not defined in spec
  • https://github.com/partiql/partiql-lang-kotlin/blob/34625c68dbcbaf7b8ae60df7a4cf65c60b2a3b79/lang/test/org/partiql/lang/syntax/SqlParserTest.kt#L3857-L3939
• Semicolon syntax -- not defined in spec; may not be relevant to all partiql implementations
  • https://github.com/partiql/partiql-lang-kotlin/blob/34625c68dbcbaf7b8ae60df7a4cf65c60b2a3b79/lang/test/org/partiql/lang/syntax/SqlParserTest.kt#L4025-L4064
• LET clause parsing -- not defined in spec yet (though there is a PR open for it: https://github.com/partiql/partiql-spec/pull/21)
  • https://github.com/partiql/partiql-lang-kotlin/blob/34625c68dbcbaf7b8ae60df7a4cf65c60b2a3b79/lang/test/org/partiql/lang/syntax/SqlParserTest.kt#L4066-L4128
• EXEC clause parsing -- not defined in spec yet
  • https://github.com/partiql/partiql-lang-kotlin/blob/34625c68dbcbaf7b8ae60df7a4cf65c60b2a3b79/lang/test/org/partiql/lang/syntax/SqlParserTest.kt#L4179-L4237
• Many nested NOT regression test -- not really a parse conformance test... more so a performance test
  • https://github.com/partiql/partiql-lang-kotlin/blob/34625c68dbcbaf7b8ae60df7a4cf65c60b2a3b79/lang/test/org/partiql/lang/syntax/SqlParserTest.kt#L4239-L4271

[alancai98]

All the partiql-lang-kotlin tests have been ported to the partiql-tests suite following merge of #14.