If you say in schema that a field is int, SQLite will ingest text happily. Even blobs on the field. No ability to rename columns. Compared to PG DML, it’s quit

If you say in schema that a field is int, SQLite will ingest text happily. Even blobs on the field. No ability to rename columns. Compared to PG DML, it’s quite restrictive. Not a toy, but plenty of gotchas