@arkemaz would you be interested in championing this?

sure I can try

@amosbastian here"s initial version without refine (the second argument) which passes insert test for mysql, pg and sqlite

https://github.com/arekmaz/drizzle-orm/blob/effect-schema/drizzle-schema/src/effect-schema.ts

edit: after some hours the insert tests are passing with refine implemented

here"s the draft pr to drizzle-orm (I think it belongs there next to drizzle-zod)
drizzle-team/drizzle-orm#2613

@amosbastian all tests are passing, insert select, with/without refine, for each db, if you want you can copy that file to your project and test it, the only thing left is some package cleanup, and probably some time will pass before they accept the merge request, if they do at all

Thanks for your hard work @arekmaz! I"ve finally got round to using it today, and it"s not 100% clear to me how we can use this to do something like

const requestSchema = insertUserSchema.pick({ name: true, email: true });

as we would with drizzle-zod, but that"s probably just me being an Effect beginner 😅

EDIT: it doesn"t work at the moment but in the end you should be able to do this:

const insertUserSchema = createInsertSchema(usersTable);
const requestSchema = insertUserSchema.pick("name", "email");

as the output schemas will be just Schema.Struct, probably I should mention that somewhere
it"s documented here

there is also the Schema.pick operator but it doesn"t work on structs for me at the moment

I"m a bit too busy to cleanup the package and request the merge at the moment,
on weekend I"ll probably get around to it

I created a new pull request drizzle-team/drizzle-orm#2665 - I"m new to commit signing

let"s see if they accept it

@datner it looks like the drizzle team did not even look at the pr, what do you think we should do with this?

maybe try to merge it into @effect/sql-drizzle? or create a standalone package? or just wait?

deferring to @mikearnaldi 🙏🏻
I am not sure what would be preferable. I default to wait but that does not guarantee a conclusion

I"d wait a bit longer and eventually evaluate if to merge in sql-drizzle

I was just looking for this today. Currently I have to define drizzle schemas, my own domain schemas and then make conversions between the two. It is a bit cumbersome, and I wish this was already available.
To me it feels much more natural to look for this kind of things in the schema repository and docs.

@danielo515 given 4 parsers: foo, bar, baz, and qux. Knowing that drizzle-orm had drizzle-foo, drizzle-bar, and drizzle-baz in their repo. Where would you expect drizzle-qux to be? How would you expect it to be named? It"s no ideal if we would be required to randomly host it on our end :
But if they are not interested we can"t force them

You can ping the PR there if you"re interested in pushing it in hehe

I updated the types slightly to account for the different modes of date, bigint, etc. Still possibly incomplete

export type GetSchemaForType<TColumn extends Drizzle.Column> =
  TColumn["dataType"] extends infer TDataType
    ? TColumn["columnType"] extends infer TColumnType
      ? TDataType extends "custom"
        ? Schema.Schema<any>
        : TDataType extends "json"
          ? Schema.Schema<Json, Json>
          : TColumn extends { enumValues: [string, ...string[]] }
            ? Drizzle.Equal<
                TColumn["enumValues"],
                [string, ...string[]]
              > extends true
              ? Schema.Schema<string>
              : Schema.Schema<TColumn["enumValues"][number]>
            : TDataType extends "bigint"
              ? Schema.Schema<bigint, bigint>
              : TDataType extends "number"
                ? TColumnType extends `PgBigInt${number}`
                  ? Schema.Schema<bigint, number>
                  : Schema.Schema<number, number>
                : TDataType extends "string"
                  ? TColumnType extends "PgNumeric"
                    ? Schema.Schema<number, string>
                    : TColumnType extends "PgUUID"
                      ? Schema.Schema<string>
                      : TColumnType extends "PgDateString"
                        ? Schema.Schema<Date, string>
                        : TColumnType extends "PgTimestampString"
                          ? Schema.Schema<Date, string>
                          : Schema.Schema<string, string>
                  : TDataType extends "boolean"
                    ? Schema.Schema<boolean>
                    : TDataType extends "date"
                      ? Schema.Schema<Date>
                      : Schema.Schema<any>
      : never
    : never;