SQLite Forum

Is there a non-trigger way to format data on INSERT/UPDATE?
Login
If space is not an issue then on recent versions of SQLite you could use generated columns[1] to achieve the equivalent.

[1] https://www.sqlite.org/gencol.html