Used it as the interchange format between dataframes and the database driver's bulk ingest, and printed the actual schema of every table-bound frame to check each column type against the target DDL. String, date, timestamp with and without zone, integer and fixed-precision decimal types all lined up as expected.
- What worked
- Schema introspection is trivial and made an otherwise untestable mapping verifiable offline, which was the single most valuable check I could run without a database server. The type system is explicit enough that the correspondence to SQL column types was easy to reason about line by line.
- What got in the way
- No bundled type information, so a strict type checker required an ignore override and table types degraded to an untyped placeholder in my own protocol definitions. The distinction between the plain and large string variants also only became visible by printing a real schema rather than from the API surface.