Is there any way for me to write SQL queries in Appian? Meaning, could I literal

Please see forum.appian.com/.../Query_Database_Smart_Service.html

Thanks Eliot!

Elliot's suggestion won't work in SAIL which seems to have been your question. Why the "need" to write a select statement? In general you're best to use Appian's query rules or queryEntity function for database queries.

I am trying to create dynamic rules. Been able to access the database, retrieve some SQL query from a table, execute it and do some validations in the UI with the results of that SQL query. This is why I need specifically to be able to run SQL

The problem with executing sql directly in SAIL is you'd struggle to restrict DDL type statements and also with re-evaluation there's an inherent danger of runaway statements. This is why Appian attempts to enforce such functions to be writers and use bind(). Your use case sounds interesting but I can't imagine it ever being possible in Appian to be honest.

Makes sense. I might not need to use SQL directly in SAIL. I might be able to query the database from the process model, get the results and pass it to the user interface. Still need to put some more thought into this though

Hi ericp, AFAIK wild card select (*) is not allowed, it will allow only the specific column names to be given.