This is explained here: Prepared statements | Retool Docs
Since most databases do not support dynamic column or table names in prepared statements, you generally cannot use {{ }} embedded expressions to dynamically specify columns or tables.
However, the workarounds there don't seem acceptable for my use-case, so I'm open to new ideas if possible!