title: NestJS Prisma ORM - Using 'select' versus 'include' when fetching data records?
body: <p>I'm trying to fetch data records from a Postgres database in NestJS (Node.JS environment).</p>
  <p>I'm using Prisma as my Object Relational Mapper (ORM) in TypeScript.</p>
  <p>I'm having trouble choosing which query to use when fetching 'ADMIN' user records.</p>
  <p>Someone please explain the difference between using 'select' versus using 'include' when fetching data records (I'm a Prisma beginner - please keep it simple).</p>
  <p>Thanks in advance!</p>
  <p>The code looks like below:</p>
  <p>Using include:</p>
  <pre class="lang-js prettyprint-override"><code>
  const users = await prisma.user.findMany({
    where: {
      role: 'ADMIN',
    },
    include: {
      posts: true,
    },
  })
  
  </code></pre>
  <p>Using select:</p>
  <pre class="lang-js prettyprint-override"><code>const users = await prisma.user.findMany({
    where: {
      role: 'ADMIN',
    },
    select: {
      posts: true,
    },
  })
  
  </code></pre>