jordiup

import { z } from 'zod';

const connectionSchema = z.object({
  user: z.string(),
  password: z.string(),
  host: z.string(),
  database: z.string(),
  port: z.number().int().positive().default(5432),
  ssl: z.boolean().default(true),
  pooling: z.boolean().default(true),

jordiup

SELECT
  EXTRACT(MONTH FROM s."shiftStart")::int AS month,

  /* ---------- average hourly rate ---------- */
  ROUND(AVG(
    CASE
      WHEN s."positionParentCategory" = 'Consultant' THEN
            CASE
              WHEN s."isDayRate"   THEN s.cost / NULLIF(s.hours, 0)
              WHEN s."isHourlyRate" THEN s.rate