In the current version of Corteza, there is no support for altering the physical table created to store records. For instance, I use “{{namespace}}-{{module}}” for the “Collection or database table name” in the module, and I also use “encode values into Column” for all data and save it. After correctly saving this module, when you want to modify the module and add a new field, it only allows you to add a new field by type JSON. It lets you save, but if you don’t have any JSON field in the original generation, it causes an issue when you want to add data in this module because, in reality, any JSON field does not exist in the DB table. The module cannot be modified to add a field, but Corteza allows it.
Another problem arises when you save the module with a special Collection or database table name, meaning creating a new table in the database to save record values. If you delete that module due to an error and need to create it again with the same name (handle), the physical table still exists because Corteza does not delete it when you delete the module, causing further issues.
I need to know if this problem exists in the current version (so I must avoid using the Column) or if I have misunderstood. I would appreciate your help with this issue.