Bug Report: Schema Migration breaks where tables have a dash "-" in their name

[Abhilash_Nair]

• Goal: migrate Retool Database schema from production to staging

• Steps:

  • Ensure Disable converting queries to prepared statements is unchecked in Resource settings for Retool Database
  • Create table in Retool Database in the production environment with a dash "-" in its name, such as example-table
  • Try Schema Migration from production to staging, it will fail on the dash "-"

• Details: Having Disable converting queries to prepared statements unchecked, from what I read here, is the safer option to avoid SQL Injection risks. It unfortunately has the side-effect of breaking Schema Migration if your tables or primary key constraints have a dash in their name. I believe it's the same reason that table names cannot be passed in as a string with this safer approach, and the parser breaks on the dash.

• Screenshots:
  

  

• App json export: Not relevant for bug.