Mysql DATE and DATETIME columns in Retool queries

There is also a setting in the resource setup for controlling whether to automatically cast MySQL date types into JS Date objects. Disabling that might get closer to what you are looking for, but keep in mind when you change it it will impact the existing logic and downstream will probably involve different work getting those non Dates to work as expected