Support sqlite in production.

Is your feature request related to a problem? Please describe.
I'm a fan of self hosting early stage and startup projects on micro budgets (think 5USD to 100USD a month at most). I've been using Temporal on work projects but more recently I've been playing with Temporalite using sqlite replicated with https://litestream.io to https://min.io. It has worked out great in development but I'd like to take Temporal (or Temporalite) to production without clusting, postgres, elasticsearch etc which all blow out small budgets in a heartbeat.

Describe the solution you'd like
Officially support sqlite in production.

I think this would involve (at least):

• Add sqlite as an option to the sql tool.
• Add sqlite support to the auto-setup shell scripts.
• Add sqlite visibility support? (perhaps requiring the fulltext search extension?).

Describe alternatives you've considered
I have been tempted to use temporalite in production despite all the risks and downsides.

Additional context
I don't fully utilise Temporal. Generally my workflows are for service to service coordination and short lived so I'm OK with a single nodes and short stretches of downtime which I understand probably isn't typical for Temporal users.

I asked about future plans for sqlite support here https://community.temporal.io/t/future-sqlite3-support/5915?u=shane

Start by locating the SQL tool and the auto-setup shell scripts mentioned in the issue, then trace how database and visibility options are configured. Investigate whether SQLite visibility requires the full-text search extension and what production constraints apply. Done would mean SQLite is an officially supported production option across the requested setup and visibility areas.