Today I had to invest quite a significant time to switch our system to use sub second precision on timestamp, datetime and time. In the end it required rewriting the relevant parts of the app to actually emit `DATETIME(6)` instead of the more generic DATETIME.

Here's the kicker though, I would have much rather kept the cross platform compatible SQL and flipped a switch on my DB to instruct it that when I leave off the precision, I actually mean `(6)` [or whatever I configured].

Is this something you are interested in adding?