title: When should I use SQL standard types over generic types in SQLAlchemy?
body: <p>Consider an instance of <code>datetime.datetime</code> from the Python standard library. We can either store such instance as the generic type <code>sqlalchemy.types.DateTime</code> or the SQL standard type <code>sqlalchemy.types.DATETIME</code>.</p>
  <p>The SQL standard type has the limitation that it will only work on those backends that explicitly support them by name as mentioned <a href="https://docs.sqlalchemy.org/en/14/core/type_basics.html#sql-standard-and-multiple-vendor-types" rel="nofollow noreferrer">here</a> . The generic type has no such limitation.</p>
  <p>Is there ever a case that using the SQL standard type is preferred over generic type?</p>