I've noticed that for columns from BigQuery tables with the data type 'DATE', while TablePlus will correctly identify the data type as being DATE within the 'Structure' tab, it seems to in practice treat them as strings.
For instance, a DATE field with a value of '2023-10-25' displays in TablePlus as "10/25/2023 12:00:00 AM".
This becomes problematic when you want to make any sort of change and commit, as it throws an error saying "Could not cast literal to type DATE"
I've noticed that for columns from BigQuery tables with the data type 'DATE', while TablePlus will correctly identify the data type as being DATE within the 'Structure' tab, it seems to in practice treat them as strings.
For instance, a DATE field with a value of '2023-10-25' displays in TablePlus as "10/25/2023 12:00:00 AM".
This becomes problematic when you want to make any sort of change and commit, as it throws an error saying "Could not cast literal to type DATE"