types(connection): make transaction() return type match the executor function

types(connection): make transaction() return type match the executor function #8738