One thing to keep in mind: the type system is extremely unusual even in simple cases compared to what I'd expect in a SQL-92 system. It's clever, giving SQLite

One thing to keep in mind: the type system is extremely unusual even in simple cases compared to what I'd expect in a SQL-92 system. It's clever, giving SQLite a lot of power in limited code, important in its conventional application in embedded use cases where fixed costs like code object size and starting database heap size are pretty constrained, and databases tend to be small...but, nevertheless, it's in its own world, there. https://www.sqlite.org/datatype3.html https://www.sqlite.org/datatype3.html