Less about the exact syntax and more about the tool, for example: https://github.com/sqlkata/querybuilder https://github.com/sqlkata/querybuilder. I just chose

Less about the exact syntax and more about the tool, for example: https://github.com/sqlkata/querybuilder https://github.com/sqlkata/querybuilder. I just chose that since it was on top of a search but the idea is the same. Your code generates raw SQL, so it's 100% interchangeable with writing SQL yourself however the builder library deals with the syntax, proper ordering, quoting, full attribute names, etc. Some such libraries even let you define your schema in code to make your SQL generation type safe.