FlexReport query returns error in query editor even though the query is syntactically correct, and doesn't contain tenant specific features such as Perspectives or account filters.
Please ensure if you're copying a FlexReport query from an external source (e.g. Monday.com) that you first copy the query into a text editor such as Notepad, Microsoft Word (Windows) or TextEdit (Mac OS) and then copy the query into the FlexReport query editor.
This will remove any potential formatting errors with control characters such as , or " or ( or { from the query and allow the query to run successfully.