Problem: SQL syntax between MySQL and SQLite3 differ in certain cases.
Example: Creating tables with a TEXT column as a primary key.
Conversation
Replying to
You can declare primary keys as a table constraint with a list of columns in SQLite which should match the syntax used by MySQL. Declaring it as a constraint on a column is the idiomatic way to do it for a single column primary key but it's not mandatory.
1
1
SQLite syntax is quite flexible with there generally being several approaches to doing the same thing as part of having syntax compatibility with other databases.
In general though, there are many differences in features and semantics across databases. Supporting multiple hurts.
1
1
For example, it's nice to declare SQLite tables as being STRICT now that it supports strict type checking along with adding CHECK constraints to fill in the missing semantics for types like booleans which you would be storing as an integer. Can't have it done well and portable.