findMany() vs findMany({...})

// src/lib/db/db.ts
import { PrismaClient } from '@prisma/client';

const globalForPrisma = global as unknown as { prisma?: PrismaClient };

export const prisma = globalForPrisma.prisma ?? new PrismaClient();

if (process.env.NODE_ENV !== 'production') {
  globalForPrisma.prisma = prisma;
}

async function listCounties() {
  try {
     console.log("DATABASE_URL:", process.env.DATABASE_URL);

    const counties = await prisma.county.findMany();
    console.log("Counties:", counties);
  } catch (error) {
    console.error("Error listing counties:", error);
  }
}

void listCounties();

//src/lib/db/list.ts
export async function getUKCounties(): Promise<County[]> {
  console.log('Fetching UK counties...');
  try {
    const counties = await prisma.county.findMany();
    console.log('FindMany result:', counties);
    return counties;
  } catch (error) {
    console.error('Error fetching UK counties:', error);
    throw error;
  }
}

const counties = await prisma.$queryRaw<County[]>`SELECT * FROM "County"`;
const counties = await prisma.county.findMany({
  where: {},
  select: {
    id: true,
    name: true
  }
});