Convert MS Graph-style query strings like $filter
, $select
, $orderby
, $top
into SQL — safely and easily.
import { buildSQL } from 'gq-to-sql';
const query = "$select=name,age&$filter=age gt 20 and name eq 'Mario'&$orderby=age desc";
const { sql, params } = buildSQL(query, { table: 'users' });
console.log(sql); // SELECT name, age FROM users WHERE age > ? AND name = ? ORDER BY age desc
console.log(params); // [20, 'Mario']
✅ Safe parameterized SQL
✅ Supports $filter, $select, $orderby, $top, $skip
🔜 Upcoming: joins, aliases, and $expand
MIT