$LISTGET is easiest. $LISTGET(a) will get the first value, $LISTGET(a,number) gets the value at that number.

Select $LISTGET(a,1) as ColumnOne, $LISTGET(a,2) as ColumnTwo  from SQLTable

You can always use <code></code> in DTL

Try Below:

<code>
<![CDATA[
    &sql(SELECT ID
    FROM TestTable
    WHERE ProviderName = 'TEST,PROVIDER' AND IDType= 'BPI')
]]>
</code>