targetBuild MUST make, from a logical schema, a dialect, a naming, a schema qualifier, the extensions' statement sources and rows (by table and column, by the words of their names), a build that holds the statements and the text of one SQL file, and MUST give errors as values for a table or a column that the schema does not have, a column a table requires (not optional and with no default) that a row leaves out, a primary key that is in the rows twice, and a cycle among tables of the foreign keys (a table that refers to itself is allowed).
Enforced (check): .github: cd commons/data && bun run verify — suite/target.test.ts: the file is a header, the structure, then rows with tables after the tables they refer to, rows in the order of their key, a fixed number to an INSERT, and the same bytes every time whatever the order the rows were given in; suite/target.test.ts: rows are checked when the file is made: an unknown table or column, a missing required column, a key twice, a column twice and a cycle among tables are errors as values
Proved by: data/suite/target.test.ts
Written in: data/sql/extensions/target/build.ts, data/sql/extensions/target/mod.ts
Tests: passed: suite/target.test.ts the file is a header, the structure, then rows with tables after the tables they refer to,; passed: suite/target.test.ts rows are checked when the file is made: an unknown table or column, a missing required col