executeQueryAsMaps method

@override Future<List<Map<String, dynamic>>> executeQueryAsMaps(JsonQuery query)

Execute a query and deserialize results to maps.

If the query includes relations via include, results are automatically deserialized into nested structures using the RelationDeserializer.

Implementation

@override
Future<List<Map<String, dynamic>>> executeQueryAsMaps(JsonQuery query) async {
  // Compile to get relation metadata
  final sqlQuery = compiler.compile(query);

  // Execute the query
  final result = await _executeWithLogging(
    sql: sqlQuery.sql,
    parameters: sqlQuery.args,
    model: query.modelName,
    operation: query.action,
    execute: () => adapter.queryRaw(sqlQuery),
  );

  // Check if we need to deserialize relations
  final hasRelations =
      sqlQuery.hasRelations && sqlQuery.relationMetadata is CompiledRelations;

  // Convert to maps - preserve aliases when relations are present so
  // the RelationDeserializer can match column aliases like "user__name"
  final flatMaps = _resultSetToMaps(result, preserveAliases: hasRelations);

  if (hasRelations) {
    final compiledRelations = sqlQuery.relationMetadata as CompiledRelations;

    // Use relation deserializer to nest flat JOIN results
    final deserializer = RelationDeserializer(
      schema: compiler.schema ?? schemaRegistry,
    );

    final deserialized = deserializer.deserialize(
      rows: flatMaps,
      baseModel: query.modelName,
      columnAliases: compiledRelations.columnAliases,
      includedRelations: compiledRelations.includedRelations,
    );

    return deserialized;
  }

  return flatMaps;
}