I've used retool with MySQL and haven't run into this issue.
But, on this project. I decided to try the retool database.
But, no matter what I try, I keep hitting the same issue. The update query wants me to supply an ID# for the id field, even though this field is the primary key and is set to auto-increment.
Retool Database Column Settings:
field name: id
field type: Number
Nullable: false
Unique: true
Default Value: devices_id_seq
Insert Query Settings:
GUI Mode: Run query only when manually triggered
Table: devices
Action type: Insert a record
Changeset: Key Value pairs
THINGS I HAVE TRIED...
1 - Not including the primary key in the field list.
2 - Using the primary key in the field list, but not providing a value.
3 - Using the NULL string
4 - Using JS Null
5 - Using the keyword from the column settings.
What is the proper way to auto-increment when inserting a record using key value pairs?