I wanted to know if it's possible to give a regex while deleting a resource.

I have documents stored in a hierarchy of collections like {year}{month}/doc.xml.

Eg: 202301/abc.xml, 202302/def.xml.

If I want to delete a resource "abc.xml", Is it possible to issue commands like "db:delete("db-name", '/*/abc.xml')" ? Right now, I can do a XQuery with db:list and endsWith and get the complete path of "abc.xml". But regex would have been very handy.

Similarly I also want to execute queries against a list of collections using regex.

Something like "for $document in collection('db-name/20230*')" (First 9 months of 2023)

Right now, I am doing something like 

"for $i in ('01', '02', '03', '04', ... '09')
for $document in collection('test-collection/2023' || $i)"

But if there are better ways, kindly let me know.

Thank you,

Deepak