Similar to Caché so also in IRIS, you have ClassQueries available in 2 variants
- Basic class queries, which use the class %SQLQuery and an SQL SELECT statement.
- Custom class queries, which use the class %Query and custom logic to execute, fetch, and close the query.