[SQLObject] Database connection outside SQLObject class instance

[Tom C. <su...@ic...>]

Hi All,

I'm new to SQLObject and was just wondering if there is a way to use a 
database connection from the pool of connections (I'm assuming SQLObject 
keeps a pool of open connections) from *outside* of an SQLObject class 
instance.

I'm using PostgreSQL as db and have a view across various tables defined in 
the database. I need to do a query using on this view before I can 
instantiate the correct SQLObject class instance.

If I already have an SQLObject class instance, I can use the 
self._connection.queryAll method to perform a generalized query on other 
tables or views in the database, but this time I can't instantiate an 
SQLObject class until I've done the query on the view.

Is there a way that I can get to the already connected SQLObject db connection 
pool and use one of these connections for the direct query on the view, or 
should I just open a new psycopg connection and use that?

Apologies if this is a stupid questions or not well formulated - I'm still new 
to all of this.

Thanks,
 Tom