> Since the DDL is created by EFCore at runtime as part of a migration, it's not really up to us. ... When I advised, "Say 'integer' rather than 'bigint'", I was not referring to the generator of that DDL. You had said, "I work on a database that has several bigint (Int64) columns as Ids." I am sure that is where that troublesome 'bigint' type arose, merely replicated by the EFCore. In SQLite, the column type incantation for an up-to-64-bit integer that serves as a primary key **and the rowid** is 'INTEGER PRIMARY KEY'. If that went into your migration, you would not be getting that problematic column definition for your "ef_temp_Thing" table's ID column.