thambaru/bal_orm.orm

Returns the normalized configuration used by this client.

Expose the underlying database client for low-level SQL operations.

Convert a query plan to SQL and execute it as a read query.

Use this for findMany, findFirst, findUnique, count, and aggregate operations.

Convert a query plan to SQL and execute it as a write query.

Use this for create, createMany, update, updateMany, upsert, delete, and deleteMany operations.

Execute raw SQL query text with positional parameters. Returns a generic record stream. Cast result rows to your model type using a type descriptor.

Execute raw SQL statement text with positional parameters. Returns the number of affected rows.

Create an executing query builder bound to this client for the given model type.

Terminal methods on the returned builder execute immediately — no separate run step required.

Primary Prisma-like fluent API entry point. Returns a typed executing query builder.

Example:

User[] users = check db.'from(User)
    .'where({status: {equals: "ACTIVE"}})
    .orderBy({id: orm:DESC})
    .findMany();

Close the underlying database client.

Scan schema payload that was derived from @orm:Entity records.

Execute plugin pipeline and return generated outputs and diagnostics.

Override table name for this query.

Add a where filter.

Add an order-by clause.

Set result offset.

Set result size limit.

Add select projection.

Add relation include payload.

Execute the query and return all matching rows as a generic record array. Cast the result to your model type using a type descriptor.

Execute the query and return the first matching row, or nil if none found. Cast the result to your model type using a type descriptor.

Execute the query and return the unique matching row, or nil if none found. Cast the result to your model type using a type descriptor.

Execute a count query and return the row count.

Execute a create query and return the created row as a generic record.

Inserts the row then fetches the full record using the auto-generated primary key. Assumes the primary key column is named id. Cast the result to your model type using a type descriptor.

Execute a createMany query and return all created rows as a generic record array.

Inserts each row individually and fetches results via auto-generated primary keys. Assumes the primary key column is named id.

Execute an update query and return the updated row as a generic record.

Updates the matching row (limited to one) then fetches back the updated record.

Execute an updateMany query and return the number of affected rows.

Execute an upsert query (insert if not exists, otherwise update).

Execute a delete query, returning the deleted row as a generic record.

Fetches the matching record before deletion, deletes it, then returns the fetched record.

Execute a deleteMany query and return the number of affected rows.

Override table name for this query.

Add a where filter.

Add an order-by clause.

Set result offset.

Set result size limit.

Add select projection.

Add relation include payload.

Build a find-many query plan.

Build a find-unique query plan.

Build a find-first query plan.

Build a create query plan.

Build a create-many query plan.

Build an update query plan.

Build an update-many query plan.

Build an upsert query plan.

Build a delete query plan.

Build a delete-many query plan.

Build a count query plan.

Build an aggregate query plan.