Read data using Native COQL Pass-through (#DirectSql)

Runs a native Zoho CRM COQL query directly by using the #DirectSql prefix. This sends the query to Zoho as server-side COQL without using an endpoint call such as SELECT * FROM get_module_data_coql WITH(...).

Use this option when you want to paste or write a full COQL statement directly in your SQL tool. This is useful for quick testing, troubleshooting, or when you prefer native Zoho COQL syntax.

Note: The #DirectSql prefix applies only to the query where it is used. It does not change the connection-wide SQL engine mode.

#DirectSql
	select Last_Name, First_Name, Email, Company
	from Leads
	where Country = 'United States'
	order by id desc