Advanced SQL (to be inserted like an HTML block or virtual field)
Dean Johnston commented
This would be a very useful feature and should be prioritised
J newsome commented
Being able to use SQL at view level as well as at table level would allow so much more additional functionality that at present really limits what you can do with Caspio, I keep hitting this wall, and its very frustrating.
AdminAdmin (Product Manager, Caspio) commented
SQL expressions, functions, CASE and SELECT statements can be used in Calculated Fields in report results page or details page. For instance, you can use SELECT statement in calculated field to get data from other tables to display or to perform additional calculations.
Kia Fallahi commented
Using SQL in views would be a perfect solution to many of our open issues. Also SQL for calculated fields in report results pages would be very useful.
Alexander Kazakov commented
Even better would be to allow using SQL to create views. And also allow to build views on data from other views (as in MS SQL Server). It will solve soooo many issues which are now blocking us using Caspio in full!
DeWight Smith commented
Absolutely. It isn't always feasible to create a view to join tables for a given Datapage. This causes a lot of DB de-normalization. A standalone query not based on the main data that is driving the Datapage would be so useful.