translate SQL to your logic UI automatically
It would be great to have an SQL tab available if you were using caspio in some kind of professional or expert mode. The tab I'm thinking of would be in the logic section of criteria where you could write the SQL logic and it would translate it into your boxy interface. in the interim you must be creating the logic in SQL so a SQL box could expose that unless it would have to be like Access writes logic in which case don't do it :)
Bill Pennock
shared this idea
-
Dave
commented
This is a good enhancement request... and the converse would also be useful. For example - I have a lot of calculated fields that are custom SQL. Caspio permits me to write custom SQL but ignores it when - for example - table or field names change. You've clearly got the capability to do this, and by not recognizing the sql you make it easier to break things.
-
Brian
commented
This is really important, I spend a lot of time trying to translate SQL into your proprietary visual tool for you to then convert it back. It is very frustrating!!