Hey HN! Colin here - a TypeScripter, open sourcer, and engineer at EdgeDB. As the creator of Zod and tRPC, I'm interested in designing tools/APIs that use type inference and generics to make life easier for devs. This query builder represents another step in that direction.<p>We set out to build an EdgeQL query builder that can express queries of arbitrary complexity (EdgeQL has feature parity with SQL, roughly) and infer the static type of the query result. We introspect the database and generate a schema-aware client that represent any query, including ones that use built-in functions, operators, string/array/tuple indexing, aggregations, conditionals, type casting, subqueries, computed properties, etc—things most ORMs can’t represent.<p>This post mostly discusses the API design, which I think will be interesting regardless of familiarity with EdgeQL. I’d love to see some of these ideas bleed into future generations of TypeScript ORMs/query builders too.<p>Best way to try it is to clone the sandbox repo and follow the instructions in the README[0]. Or jump into the docs[1].<p>[0] <a href="https://github.com/edgedb/mcu-sandbox" rel="nofollow">https://github.com/edgedb/mcu-sandbox</a><p>[1] <a href="https://www.edgedb.com/docs/clients/js/querybuilder" rel="nofollow">https://www.edgedb.com/docs/clients/js/querybuilder</a>