SQL Repository

Domain-shaped CRUD over a single table. Each kind takes a table and a connection and exposes a typed invocable whose inputs describe the operation in domain terms (filters, data) instead of raw SQL.

Why use this

• Domain-shaped inputs — pass filters or data objects; the module generates parameterized SQL.
• No new controllers — each kind is a parameterized template that expands into Sql.Query / Sql.Exec resources at load time.
• Transaction-aware — generated invocations honour Sql.Transaction via AsyncLocalStorage exactly like hand-written SQL.
• Straightforward CRUD — ideal for HTTP routes fronting a single table, admin panels, and simple internal APIs.

Kinds

Kind	Purpose
SqlRepository.Read	Reads rows from a table filtered by an equality map.
SqlRepository.Create	Inserts a row from a domain object.
SqlRepository.Delete	Removes rows matching an equality map.

Example

kind: Telo.Application
metadata: { name: users-api, version: 1.0.0 }
imports:
  Sql: std/sql@0.9.2
  SqlRepository: std/sql-repository@0.3.0
secrets:
  DATABASE_URL: { type: string }
---
kind: Sql.Connection
metadata: { name: Db }
connectionString: "${{ secrets.DATABASE_URL }}"
---
kind: SqlRepository.Read
metadata: { name: FindUsers }
connection: { kind: Sql.Connection, name: Db }
table: users
---
kind: SqlRepository.Create
metadata: { name: InsertUser }
connection: { kind: Sql.Connection, name: Db }
table: users
---
kind: SqlRepository.Delete
metadata: { name: RemoveUser }
connection: { kind: Sql.Connection, name: Db }
table: users

Invoke from a handler step:

handler:
  kind: SqlRepository.Read
  name: FindUsers
inputs:
  filters:
    email: "${{ request.query.email }}"
    status: active

When to Use It

SqlRepository.* is designed for straightforward CRUD. When you need joins, aggregates, OR groups, LIKE predicates, paging, or anything beyond strict equality, drop down to Sql.Select or Sql.Query directly. A SqlRepository.Delete without filters would generate invalid SQL (DELETE FROM users WHERE) — make sure every invocation supplies at least one filter.