executeQueryMulti method

Future<Result<QueryResult>> executeQueryMulti(String connectionId, String sql)

Executes a SQL query that returns multiple result sets.

Some databases support queries that return multiple result sets. This method handles such queries and returns the first result set. The connectionId must be a valid active connection. The sql must be a non-empty SQL statement.

Returns a ValidationError if SQL is empty.

Implementation

Future<Result<QueryResult>> executeQueryMulti(
  String connectionId,
  String sql,
) async {
  if (sql.trim().isEmpty) {
    return const Failure<QueryResult, OdbcError>(
      ValidationError(message: 'SQL query cannot be empty'),
    );
  }
  return _repository.executeQueryMulti(connectionId, sql);
}