qb.modify won't let you access a custom column, you'll need to resort to raw SQL.
There is a qb.query module that will help you with making connections to the MySQL server, you can find it in $QBDIR/api/python/qb. Since it's pure python, you'll need to have the MySQLdb python module available to use it.