🚀 go-pugleaf

I want to create a data module for use in a report, that selects
specific records from a parent table, specific records from a child
table, links the two, and constrains parent records to those in the
child table.  I can't figure out how to do this with sql.  In dos, I
would :
sele 1
use procs order claimno
sele 2
use claims
set rela to claimno into procs
set filter to closed = false and procs->tos = 'X'
In the dmd, I am trying 'select * from claims WHERE closed = false' and
'select * from procs WHERE tos = "X"'; then setting master rowset, etc.
but how do I now constrain the parent records?  (.sql query is out
because I want to write to the tables as report is processing.) Thanks
for help.

Patricia