Fix missing LOOKUP_SEP constant
Use a regular property for supports_transactions
Allow all types for auto pk values, let the database handle validation