[FEATURE]: Declare Standard Schema directly in the table schema definition

### Feature hasn't been suggested before.

- [x] I have verified this feature I'm about to request hasn't been suggested before.

### Describe the enhancement you want to request

Instead of always extending the table schema with schema adapters (eg Zod) let me refine the schema directly on the table definition (so I can have enum types from Zod or other types from it).
Moving from Schema adapters to Standard Schema is a great first step.