iNav Run SQL Scripts

I have a curiosity question in regards to the iNav Run SQL Scripts
dialog window... What exactly constitutes an SQL Script from iNav's point
of view? I have entered multiple, standalone SQL statements in the script
window and executed those statements one at a time. But, what I would
like to know is if you can enter multiple SQL statements that interact
with each other (a.k.a., a compound SQL statement) in much the same manner
as an internal SQL stored procedure?

I know I could create an actual stored procedure and then execute
it, but I would like to be able to just enter the compound SQL statement
(loops, calculations, variables, and all) and execute it without having to
create an SQL object. Basically, I have a need right now to be able to
spin through say, 600 libraries and count the number of rows in a
like-named table in each of those libraries, accumulate the output into a
temporary table, and then display the results at the end. Does the iNav
support that? I could just try it, but I thought I'd ask first. ;-)

Sincerely,

Dave Clark