Allow specifying a timezone for SQLite datetime columns in the viewer

[s0nerik]

What

Having ability to specify the "source timestamps timezone" for SQLite timestamps would be really useful.

Why (problem/use case)

In SQLite, there's no easy and widely-supported way of forcing datetime columns to have a timezone specified. Closest I could come up with for my setup was using _time_format=datetime&_timezone=UTC in the DSN. But having this setup, I must always keep in mind that all timestamp column values I see are actually in UTC, even though I see them without any timezone markers in the DBCode's viewer. I'd really love to have an option to specify that the database's datetime columns contain UTC values only, so that the viewer can automatically translate them into my local timezone.

[mikeburgh]

So you can sort of do this now with column formatters, but would be a custom funciton.. thinking about making it a feature.. a few questions:

• Apply it to all datetime fields in the DB ? I assume yes if they don't have any TZ information in them
• Do you want it to be applied to the grid results and exports of the data or just the grid results ?
  

[s0nerik]

I believe that having some kind of a global setting and temporary per-viewer override would've been the best. But having only a DB-wide setting fits my use case as well.

I'm only interested in the viewer grid data formatting, not exports.

[mikeburgh]

I have released this in 1.32.4, it's a new column formatter you can apply for system timezone. I added an option to apply formatters at the datatype level, not just name of the column. This way you can apply it and it will format any column in the connection for that datatype.