Mediawiki-utilities/mwdb
This library provides a set of utilities for connecting to and querying a MediaWiki database.
The mwdb.Schema object is a thin wrapper around an sqlalchemy Engine and MetaData that adapts to the local database setup. When using a mwdb.Schema member table ORM, the internal mapping will translate between public replicas views (e.g. revision_userindex, logging_userindex and logging_logindex) transparently. This allows you to write one query that will run as expected on either schema.
At the moment, the execute() method does not make any such conversion, but a helper attribute public_replica that is True when querying views via a public replica and False when querying the production database.