Make Slonik runtime validation non-Zod specific

[gajus]

Desired Behavior

I should be able to initiate sql tag and pool with types that override the base Zod types.

I initially thought this would be a huge lift, but after doing some refactoring realized that we really need to override just two types: ZodTypeAny and z.infer.

Therefore, Slonik could be made non-Zod specific with an API similar to:

import { createSlonik, type SlonikDatabasePool } from 'slonik';
import { type ZodTypeAny, type z } from 'zod';

export const {
  createPool,
  createSql,
} = createSlonik<z.infer, ZodTypeAny>();

export type DatabasePool = SlonikDatabasePool<z.infer, ZodTypeAny>;

(This is just a rough idea, not a suggestion for the API.)

Then the consumer of Slonik would create a file in their project that sets up Slonik and consume exports from that file throughout their project, rather than directly importing from Slonik (that's already the recommended pattern anyway).

Motivation

Not everyone uses Zod.

Implementation

N/A

[mmkal]

This is roughly what I was going for in #371

[gajus]

This is roughly what I was going for in #371

Blocked some time this evening to refresh memory.

Sorry that it got pushed aside; at the time I was overwhelmed with feedback.

[CodePsy-2001]

Wouldn't a middleware approach be better? It seems odd that you have to install the zod library to not use zod.

[jareware]

FWIW, there's plenty of us out there who love Slonik, but would also love to be able to use something else than Zod. Not that there's anything wrong with Zod itself, but we have a non-trivial amount of code already using io-ts, and it'd be a bit silly to have both around.

[GianaS]

@gajus Is there any intention to see this through? My team is finding the Zod requirement to be very clunky with v37 since we already heavily rely on runtypes. If not, we unforunately may have to consider a Slonik alternative 😞

[gajus]

Realistically, not within any reasonable timeframe. It is something I would want to support, but it is big lift to do it properly, and I have no commercial reason to undertake it.