What are "real types and the associated constraints"? It has strict tables:

https://www.sqlite.org/stricttables.html