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

erickp over 8 years ago

Is there any way for me to write SQL queries in Appian? Meaning, could I literally write select * from tableName in SAIL or using a smart service? I am in need of doing that. If this doesn't exist right now, will it be an option at a later release?

Discussion posts and replies are publicly visible

Parents

0 Tim
Certified Lead Developer
over 8 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Tim
Certified Lead Developer
over 8 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data