[pysqlite] [APSW 3.6.3-r1] Embedded SELECT?

Hello

I'd like to make sure APSW allows two SELECT once into the other:

=====
sql = 'SELECT id FROM table1 WHERE number=0';
rows=list(cursor.execute(sql))
for id in rows:
	if id[0]:
		[...]
		sql = 'SELECT id FROM table2 WHERE url GLOB "%s"' % url
		company=list(cursor.execute(sql))
		for row in company:
			[etc.]
=====

I'm trying to debug a script, and I need to make sure the code above 
is legit before looking elsewhere.

Thank you.