Hi @shainegordon

Try doing:

const queryResult = await prisma.queryRaw('select * from "public"."Client"');

Hey @chenliu9 👋 ,

We have this note in our docs regarding $queryRaw:

Note: You cannot pass a table or column name into a tagged template placeholder.

If you really need to have a dynamic table name, you would have to do plain string concatenation before passing it in to $queryRaw.

Posting this for anyone else looking at this in the future (since this is ranking high in Google search).

Here is how you can filter on the existence of a one-to-one relation in prisma:

// to find records that have a relation
where: {
  relation: { isNot: null }
}
// to find records that don't have a relation
where: {
  relation: { is: null }
}

Here is how you can filter on the existence of a one-to-many relation in prisma:

// to find records that do have at least 1 relation
where: {
  relation: { some: {} }
}
// to find records that don't have any relations
where: {
  relation: { none: {} }
}

@webnoob 👋

This will work:

  await prisma.permissionGroup.findMany({
    where: {
      OR: [{ companyId: 1 }, { AND: [{ companyId: null }, { userId: null }] }],
    },
  })

After doing some light research, It looks like you possibly need double-quotes. Try

let items = await prisma.$queryRaw`SELECT * FROM "Item" ... blah blah

I say this because PostgreSQL tables names and columns default to lowercase when not double-quoted. If you haven't built much of your db, it may be worth wild to make all the tables and columns lowercase so that you won't have to keep adding double quotes and escaping characters.

References:

• PostgreSQL support
• Are PostgreSQL columns case sensitive?

The where parameter exists at the top level of the query options but you can still use it to specify conditions on relations.

await prisma.post_engagement.findMany({
    select: {
      user: true
    },
    where: {
      user: {
        enabled: true,
        deleted_at: null
      }
    }
  })