sqlkata / querybuilder

SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
https://sqlkata.com
MIT License
3.08k stars 498 forks source link

Documentation on Writing a Compiler #648

Closed lawrence-vo closed 11 months ago

lawrence-vo commented 1 year ago

Is there any documentation or guides on how to write a compiler?

I would like to use SqlKata to generate queries for Snowflake. I've noticed that there is an implementation in this repo, but it is not up to date with this main branch.

ahmad-moussawi commented 11 months ago

You can check the existing compilers; I'd recommend starting with the SQliteCompiler.

In short, you have to override the base Compiler class and use it.