Just set up a local postgresql server running postgresql 14 and set up a simple table.
Testing this on a local nodejs project - a simple query like the one on your screenshot runs perfectly fine:
My database is hosted on AWS RDS. It is accessible from local web server, and the Wappler database manager works well. Only custom queries are not executed in ‘build query’. I can check the query data responded by local server
I tried it on another desktop that didn’t update to 4.7.3, and the custom query runs well. I want to share what is the current version, but I don’t know how to check it.
Running heavy queries on other computers also results in bugs. Deleting and reinstalling the Wappler also results in a bug. After saving the file to a remote git, I even tried to create a new project.
It’s so hopeless. Please check my error report.