ENUMs are a confounding data type when used in data entry / edit forms and update / insert queries:
If I try to insert or update Retool DB table with a GUI mode Insert or Update and provide the form.data object, I get an error that the ENUM value from the form (the .value property of a Select component) is not in a valid format. So, I have to use the key / value pair method.
This appears to be required because a Select .value property sometimes is an array and sometimes a string, which seems weird, but I've watched it happen.
Is the above expected behavior? Am I using ENUMs incorrectly by populating a Select with the ENUMs (as both .value and .name)?