I can connect to the database normally with the normal input tool. I can even see my SQL query returning results in the Dynamic Input Tool preview where I press refresh before finalizing the tool's settings. But trying to actually run the workflow I always get the error "Unable to translate alias" at the dynamic input tool.
Why is that? The query is correct and it clearly can pull data or else its preview window wouldn't even get populated. I would really like to use a Dynamic Input tool instead of a normal one as I'll be having user inputs modifying the SQL query and from what I understand it's best practice to use a dynamic input tool in those cases since it has a built in interface for how to handle SQL query modifications