Prisma Dart client v4.0.0-alpha.2

[medz]

To install Prisma Dart client v4.0.0-alpha.2 run:

dart pub add orm:4.0.0-alpha.2

Or update your pubspec.yaml file:

dependencies:
  orm: 4.0.0-alpha.2

What's Changed

1. Change Dart SDK version to ^3.2.0
2. Support RAW query and execute feature, See Raw queries

Raw queries

You can use $raw to execute raw queries

$raw.query

Execute a raw query, for example:

final result = await prisma.$raw.query('SELECT * FROM "User"'); // PostgreSQL

$raw.execute

Execute a raw query, for example:

final result = await prisma.$raw.execute('DELETE FROM "User"'); // PostgreSQL

Parameters

$raw.query and $raw.execute support parameters, for example:

// PostgreSQL
final result = await prisma.$raw.query(
  'SELECT * FROM "User" WHERE "id" = \$1',
  [1],
);

// MySQL
final result = await prisma.$raw.query(
  'SELECT * FROM `User` WHERE `id` = ?',
  [1],
);

SQL template string see your used database.

---

This discussion was created from the release Prisma Dart client v4.0.0-alpha.2.