Budibase Unable to Load Grid When Using External Postgres Database with Time Column

[austinmedina]

Hosting

• Self
  • Method: docker-compose
  • Budibase Version: 3

Describe the bug
As the header states, when I try to load a table from my external Postgres database which contains a column of type Time to the data sources section and the premade tables page budibase throws me an error saying Invalid Time Value. This is very similar to issue #9050 . The problem is I cannot use the fix provided because I do not have the option to edit columns or create a view:

To Reproduce
Steps to reproduce the behavior:

1. Create a Postgres database with a table containing a column with datatype Time:SeriesID SERIAL PRIMARY KEY,
   ```CREATE TABLE Series ( SeriesID SERIAL PRIMARY KEY, StartTime TIME NOT NULL ); INSERT INTO Series (StartTime) VALUE('11:00');```
   CREATE TABLE Series ( SeriesID SERIAL PRIMARY KEY, StartTime TIME NOT NULL ); INSERT INTO Series (StartTime) VALUE('11:00');
2. Connect the Postgres database to Budibase using sources
3. Open the series table in the sources tab

Expected behavior
I expect the table to be loaded as normal with the time listed as it does in PSQL and/or give me the option to read the column as a datetime, time, etc.

[linear]

BUDI-8195 Budibase Unable to Load Grid When Using External Postgres Database with Time Column