There is a very useful shorthand for Node Mysql where it automatically spreads all object values as column values like this:
'INSERT INTO `table` SET ? ;', [someobject]
or
'UPDATE `table` set ? WHERE id = ?',[someobject,id]
This is very handy as it allow for maintainable code with very large objects (30+ columns)
But one of the columns is a Timestamp value in Mysql and the data on the node app is as a Linux timestamp (integer), Mysql doesn't automatically map this integer. I usually do something like :
FROM_UNIXTIME(?) to automatically convert this to a full date string on the (database) server.
How can I keep this shorthand technique with a timestamp insertion? I could modify this parameter beforehand in node, but nothing guarantees me the node server and the database are on the same timezone.