#sql

Building thoughtful software with AI.Notes from the systems behind the work.

March 31, 2026article

Discount report went looking for a supplier named Unspecified

The Unspecified card on my discount report filtered for the literal word instead of the rows with no supplier, which SQL can never match. A shared marker and one filter builder fixed the drill-down, with a few gaps I can still see in the diff.

databases sql reporting

4m read

Also new

December 20, 2025 4m
Tool cost report billed one model call three times
October 28, 2025 4m
Approval chart filed every human yes under automatic
October 24, 2025 5m
Usage tool checked the tenant, then pasted the next argument straight into the SQL

September 2025

September 21, 2025article

A login that knew only one spelling of the column it searches on

Some of my databases name the lookup key column differently, and since SQL won't bind a column name, I pick it from a two-item list in the code by asking the schema, then let each caller decide what a miss means.

databases sql compatibility

4m read