Scripts - Queries

Thanks for the reply.

To be clear, a sample query something like this.

SELECT * FROM `lam_leaves` WHERE leave_type_id in (SELECT leave_type_id from lam_leave_type) GROUP BY from_date;

How complex query we can directly use in Appian. generally approach is we are using SP to query and store it in temp table and then capture the result from it.