TinyJoin logoTinyJoin

ColumnType

The ColumnType type names one of the five runtime types a column holds.

"boolean" | "integer" | "float" | "text" | "json"

Each SQL type name maps to one of them: INTEGER and BIGINT to integer, REAL and DOUBLE PRECISION to float, TEXT and VARCHAR to text, and JSON and JSONB to json. The schema keeps the runtime type, not the name the table was declared with, and the length of a VARCHAR(n) as its column's maxLength.