Skip to content
sqlingo API Reference

Guide

DescriptionLearn the core workflow: parsing SQL to AST, navigating the tree, transpiling between dialects, optimizing queries, and building SQL from code.

This guide teaches the concepts behind sqlingo step by step. Each page builds on the previous one, so reading in order is recommended.

The central idea is simple: SQL goes in as a string, becomes a tree of objects, and comes back out as a string. Transpiling, optimizing, and building are all variations of this cycle.

  1. Parsing and trees: how SQL becomes an AST and how you navigate and transform it

  2. Transpiling: converting SQL between dialects by mapping functions, types, and syntax

  3. Optimizing: using schema information to simplify, qualify, and clean up queries

  4. Building queries: constructing SQL programmatically with a fluent API