The SQL command to create this view and do the conversion would look like this: CREATE VIEW YOURSCHEMA.WORKAROUNDVIEW as select … , CONVERT ( TIMESTAMP , TSLTZ) AS DTCONVERTED from YOURSCHEMA.

Nodejs SQL Parser Parse simple SQL statements into an abstract syntax tree (AST) with the visited tableList, columnList and convert it back to SQL.