Custom Query returning error when executed in Query Builder UI

Wappler Version : 4.3.2
Operating System : MacOS
Server Model: NodeJS
Database Type: MSSQL
Hosting Type: NodeJS (Local Web Server)

Expected behavior

When executing a custom query in the builder UI, it should return a Query Result

Actual behavior

The query is returning an error in the Custom Query builder UI. The issue is only in the builder UI.

It’s returning the Schema correctly in builder UI and also returning data successfully when running in the SA. Code Method: SQL

How to reproduce

1. Add a Database Custom Query in a SA
2. Execute Query to check Schema and Query Results
3. An error notification is generated in the custom query builder UI - Request Failed: error,
4. When executed in the SA, it returns the data correctly

Screen Shot 2021-11-26 at 11.07.04 am697×397 16.2 KB