Returns collection information about all collections in ThingsDB.
See the collection_info() function documentation for an example of the exposed collection information.
If the user has no EVENT permissions on the
@thingsdb scope, then only the collections where
the user has at least QUERY privileges are included in the result.
This function does not generate an event.
List with collection info about all collections in ThingsDB.