Function fromDrizzle

packages/core/fumadb/src/adapters/drizzle/query.ts:169–432

(
  schema: AnySchema,
  _db: unknown,
  provider: SQLProvider,
  interactiveTransactions: boolean = true,
  maxBoundParameters?: number
)

 * Require drizzle query mode, make sure to configure it first. (including the `schema` option)
 */
export function fromDrizzle(
  schema: AnySchema,
  _db: unknown,
  provider: SQLProvider,
  interactiveTransactions: boolean = true,
  maxBoundParameters?: number
): AbstractQuery<AnySchema> {
  const [db, drizzleTables] = parseDrizzle(_db);

  async function executeRaw(statement: string) {
    const target = db as unknown as {
      run?: (query: Drizzle.SQL) => unknown;
      execute?: (query: Drizzle.SQL) => Promise<unknown>;
    };
    const query = Drizzle.sql.raw(statement);

    if (target.run) {
      await target.run(query);
      return;
    }

    if (target.execute) {
      await target.execute(query);
      return;
    }

    throw new Error("[FumaDB Drizzle] Database cannot execute raw transaction statements.");
  }

  function toDrizzle(v: AnyTable): TableType {
    const out = drizzleTables[v.names.drizzle];
    if (out) return out;

    throw new Error(
      `[FumaDB Drizzle] Unknown table name ${v.names.drizzle}, is it included in your Drizzle schema?`
    );
  }

  function toDrizzleColumn(v: AnyColumn): ColumnType {
    const table = toDrizzle(v.table!);
    const out = table[v.names.drizzle];
    if (out) return out;

    throw new Error(
      `[FumaDB Drizzle] Unknown column name ${v.names.drizzle} in ${v.table.names.drizzle}.`
    );
  }

  // Drizzle Queries doesn't support renaming fields with `mapWith` because https://github.com/drizzle-team/drizzle-orm/issues/1157
  // we need to map the result on JS instead of relying on Drizzle
  function buildQueryConfig(
    table: AnyTable,
    options: SimplifyFindOptions<FindManyOptions>
  ) {
    const columns: Record<string, boolean> = {};
    const select = options.select;

    if (select === true) {