Add the DBIEngine role to pg.

Also move the role declaration to the top of sqlite.pm; it just
required that `dbh` be defined, and it is too early for the attribute to be seen,
otherwise.