You can embed SQL within ObjectScript on InterSystems IRIS® data platform.
Embedded SQL allows you to include SQL code within an ObjectScript program. The syntax is &sql( ). For example:
&sql( SELECT Name INTO :n FROM Sample.Person ) WRITE "name is: ",n
For further details, refer to the Using Embedded SQL chapter in Using InterSystems SQL.