Use strict table with SQLite 3.37 and above

Problem/Motivation

Currently SQLite provides flexible inserting of values inside tables. For example inserting FALSE into a integer value results in a 0. But this is not common Behaviour in our other databases. To streamline this more so we can create beter (and wider) covering tests we should use the strict mode implemented in SQLite 3.37.

Documentation about this change can be found here.

The current minimum version for SQLite is lower than the required minimum for this change, hence we have to do this in Drupal 11.

Steps to reproduce

1. Using SQLite create a table with a integer field.
2. Insert a string with numbers in the field
3. SQLite will automatically create a integer from the string

Proposed resolution

Use strict mode on all tables.

Remaining tasks

T.B.D.

User interface changes

None

API changes

None

Data model changes

None

Release notes snippet

T.B.D.