Trouble with Active Query Builder – SQL Parsing Errors?

Hi everyone,

I have been using Active Query Builder for a while now but recently I have been encountering a lot of SQL parsing errors when working with more complex queries. I am not sure if I am missing something in the configuration or if there’s a specific syntax that the tool does not handle well.

Here are a few examples of issues I have run into:

• Nested Subqueries: Whenever I try to use multiple nested subqueries, the tool seems to struggle with parsing them correctly. Anyone else facing this issue: ??
• Custom Functions: I am using a few custom SQL functions in my queries, and it seems like the builder doesn’t recognize them, causing parsing to fail.
• Joins Across Multiple Databases: I often work with cross-database queries but Active Query Builder sometimes doesn’t interpret these joins correctly. Any advice: ??

Is there a workaround for these problems: ?? Or maybe some setting I have overlooked that could fix this: ?? I would appreciate any help or insight from those who have run into similar issues: I have also went through this https://stackoverflow.com/questions/42419383/why-do-i-get-an-sql-parsing-error-when-i-use-parameters-cissp/ but looking for more tips and advice.

Thanks in advance !!

David Miller