Dialect-specific parsing and Snowflake JSON support

Hi ,

Currently the lib support different databases (postgresql-sql, mysql , etc .. ) dialect only in the tokenizer.

My question is - if there was any discussions/plans about supporting per-db dialects also in the parser (or do you you think it's good idea to start such discussions )?

Where most of the DB's support ANSI sql , when it's come to more advance features like json-parsing - There is great variability between the different databases.

The issue names the tokenizer and parser, with existing postgresql-sql and mysql dialects as comparison points. First review how those dialects are handled and clarify the Snowflake JSON syntax that must be supported. Done requires a decided parser-dialect scope and implementation plan; the issue does not name files or tests.

Written by the indexing model from the issue text.