This is simple helper for dynamic pagination using drizzle-orm using basic limit offset. The result is fully typed.
import { db } from "../yourdbinstance";
import { sql } from "drizzle-orm";
import type { PgSelect } from "drizzle-orm/pg-core";
interface PaginateParam {
limit: number;
page: number;