Bug: SQLite incompatibility

[crayolakat]

Describe the bug
SQLite is the default database engine for Spoke development environments, but is not compatible with Spoke.

To Reproduce
Steps to reproduce the behavior:

1. Follow the instructions here to set up your development environment. Use the default SQLite as your database engine- don't set up Postgres or Docker.
2. Create an organization and campaign
3. Set up some fake contacts in the campaign and assign all of them to yourself
4. Switch to Texter mode and send some of the texts, but not all
5. Go back to Admin mode and click the campaign you just created
6. Next to your texter's name, click the "Unmessaged" hyperlink
7. Issue: There is a GraphQL error. The Spoke terminal describes the following errors: Query cancelling not supported for this dialect and value is not an instance of Date

Expected behavior
SQLite should either be made compatible with Spoke, or removed as the default database engine and Spoke should stop supporting it.

Screenshots

Platform:

• OS: MacOS
• Browser: Chrome
• Desktop
• Version: 106.0.5249.119

Additional context
I didn't search for more SQLite errors after encountering the described errors above. There may be more.

[engelhartrueben]

Issue still persists into Spoke v14.0 - adding to To-Do list