A familiar SQLite workflow, extended to other databases

The brief was specific: keep familiar operations for inserting, updating, upserting, creating tables, and inspecting their structure, then test against PostgreSQL, SQLite, and DuckDB.

Codex and GPT-5.6 Sol produced a prototype that needed relatively few follow-up prompts before an alpha release. The examples are satisfyingly concrete: print rows from a PostgreSQL table, or pipe San Francisco’s street-tree CSV into DuckDB and have the table schema inferred automatically.

The first tree import took nearly an hour. A subsequent optimization brought that particular run down to about 35 seconds.

Version 0.1a0 is an experiment to try and inspect. It demonstrates how quickly an existing library’s design can become a working exploration of a broader API, with actual databases and a real import workload providing feedback.