$queryRaw method

Future $queryRaw(
  1. String query, {
  2. Iterable parameters = const [],
})

Query raw SQL.

Example:

final result = await prisma.$queryRaw('SELECT * FROM User');

Implementation

Future<dynamic> $queryRaw(
  String query, {
  Iterable<dynamic> parameters = const [],
}) async {
  final String sdl = GraphQLField(
    'mutation',
    fields: [
      GraphQLField(
        'queryRaw',
        args: [
          GraphQLArg('query', query),
          GraphQLArg('parameters',
              json.encode(prismaRawParameter.encode(parameters))),
        ],
      )
    ],
  ).toSdl();

  // Request the query.
  final GraphQLResult result = await _engine.request(
    query: sdl,
    headers: _headers,
    transaction: _transaction,
  );

  // Get query result.
  final dynamic queryRawResult = result.data?['queryRaw'];

  // Return the result.
  return prismaRawParameter.decode(queryRawResult);
}