[panzi]

I also want to be able to debug the database in an SQL console with nice looking date-times.

[thaumasiotes]

You can already do that: https://sqlite.org/lang_datefunc.html

[masfuerte]

Just to state the obvious, you can create a view which uses these functions to make your integer date/times readable, and then debugging is easy.