I really used this library only once, and it was almost a year ago, so I'm not certain, however, this worked as per what I can remember: http://clsql.b9.com/manual/with-database.html
. What this means is that when you do connect-databases, it creates a connections pool, but before you can run a select query, you need to tell clsql what database are you targeting (there may be multiple open connections at the same time). This macro seem to be doing exactly that. I.e. once you select some database, you would query that database inside the macro.