Microsoft.Data.Sqlite: Handle column type ANY

[bricelam]

SQLite 3.37.0 added support for STRICT tables which codified a new column type name--ANY. We should review the places we use the column type name and make sure we're handling ANY appropriately.

For example, SqliteDataReader.GetFieldType should probably return object when the column type is ANY.

[roji]

Whoa, is SqlClient Sqlite a proper strongly-typed relational database now? 🤣

We could also add migration support for the new STRICT table setting in the EF provider (or even... make it the default 🔥🔥🔥)

[roji]

After all, the Sqlite docs themselves say some developers "are aghast at SQLite's flagrant rule-breaking" 🤣

[ErikEJ]

@roji

Whoa, is SqlClient a proper strongly-typed relational database now?

Assume you mean SQLite (SQL Server has always been that)

[roji]

Of course, corrected.