Schema-Validated SQL for Go. DBML In, Safe SQL Out.

import "github.com/zoobz-io/astql"

// Schema from DBML — single source of truth
instance, _ := astql.NewFromDBML(project)

// Typos caught immediately: instance.F("emial") panics with a clear error
query := astql.Select(instance.T("users")).
    Fields(instance.F("email"), instance.F("name")).
    Where(instance.C(instance.F("active"), astql.EQ, instance.P("is_active"))).
    OrderBy(instance.F("email"), astql.ASC).
    Limit(10)

// One AST, four databases
pg   := query.Render(postgres.New())  // "email", LIMIT 10
lite := query.Render(sqlite.New())    // "email", LIMIT 10
my   := query.Render(mariadb.New())   // `email`, LIMIT 10
ms   := query.Render(mssql.New())     // [email], FETCH NEXT 10

// SQL: SELECT "email", "name" FROM "users"
//      WHERE "active" = :is_active ORDER BY "email" ASC LIMIT 10
// Params: [is_active]