Store human readable table names in separate SQL table

Currently tables are named “table_32141” and I can access them via SELECT _id FROM data_tables.table_32141.

I would like to be able to run SELECT human_readable_name, numeric_name FROM table_map to see that table_32141 is called “my_table” in the IDE.

This would be useful for SQL queries but it could be implemented into the anvil.tables API and used in https://anvil.works/forum/t/get-app-table-table-object-by-table-id/. Two birds with one stone!

2 Likes