dbgate-sqltree

dbgate-sqltree is a JavaScript/TypeScript SQL query-builder library that represents SQL queries as raw JSON objects. The current stable version is 7.1.13. It supports multiple SQL dialects including MySQL, PostgreSQL, MSSQL, and SQLite through driver plugins. Unlike ORM-based solutions, it provides a low-level, flexible JSON structure for constructing queries programmatically. The library is part of the dbgate ecosystem and relies on external database plugins for SQL dialect specifics. It is primarily used for generating SQL strings from query trees.