Prisma `groupBy` dates snippet

schema.prisma

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "sqlite"
  url      = "file:./dev.db"
}

model User {
  id    Int     @id @default(autoincrement())
  email String  @unique
  name  String?
  posts Post[]
}

model Post {
  title     String
  content   String?
  id        Int      @id @default(autoincrement())
  published Boolean  @default(false)
  createdAt DateTime @default(now())
  author    User?    @relation(fields: [authorId], references: [id])
  authorId  Int?
}

script.ts

import { PrismaClient } from "@prisma/client"

const prisma = new PrismaClient()

async function main() {
  try {
    await prisma.post.groupBy({
      by: ['createdAt'],
    })
    
    // where date is less than or equal to
    await prisma.post.groupBy({
      by: ['createdAt'],
      where: {
        createdAt: {
          lte: '2021-10-19T07:25:40.634Z'
        }
      }
    })
    
    // ascending order
    await prisma.post.groupBy({
      by: ['createdAt'],
      orderBy: {
        createdAt: 'asc' // or 'desc'
      }
    })
  } catch (error) {
    throw error
  }
}

main()