SafeQL ❤️ Prisma

SafeQL is compatible with Prisma which supports raw queries as well, and very straightforward to use!

First, Make sure you've added @ts-safeql/eslint-plugin to your ESLint plugins:

json

// .eslintrc.json
{
  "plugins": [..., "@ts-safeql/eslint-plugin"],
  ...
}

Second, add the following rule to your ESLint config:

json

// .eslintrc.json
{
  // ...
  "rules": {
    // ...
    "@ts-safeql/check-sql": [
      "error",
      {
        "connections": [
          {
            // The migrations path:
            "migrationsDir": "./prisma/migrations",
            // A shadow database name (see explanation in Configuration):
            "databaseName": "my_db_shadow",
            // The name of the variable that holds the connection:
            "name": "prisma",
            // An array of operators that wraps the raw query:
            "operators": ["$queryRaw"]
          }
        ]
      }
    ]
  }
}

Lastly, you'll be able to write queries like this:

typescript

const query = prisma.$queryRaw(sql`SELECT * FROM users`);

Lastly, SafeQL will be able to lint your queries like so:

typescript

const query = prisma.$queryRaw(
    Prisma.sql`SELECT idd FROM users`
                      ~~~ Error: column "idd" does not exist
);

SafeQL ❤️ Prisma #

SafeQL ❤️ Prisma