Supabase Typed Query Builder – Type-safe select builder

[Auguste-Houndjago]

Supabase Typed Query Builder

Hi everyone 👋

I’ve built a small TypeScript utility that lets you safely build .select() queries for Supabase — with full relation typing, autocomplete, and Cache Helper compatibility.

No more guessing nested select strings — everything is typed and predictable 💪

🧩 Package: supabase-typed-query-builder
💻 Source: GitHub – auguste-lab/supabase-typed-query-builder

---

🚀 Example usage

import { buildQuery } from "supabase-typed-query-builder"

const query = buildQuery("User", {
  select: { id: true, email: true },
  include: {
    UserOrganization: {
      select: { role: true },
      include: {
        Organization: {
          select: { name: true },
        },
      },
    },
  },
})

// Result: "id,email,UserOrganization(role,Organization(name))"

export function getUser() {
  return supabase.from("User").select(query).eq('email', '[email protected]')
}

💡 Example with Cache Helpers


"use client"

import { getUser } from '@/lib/supabase/actions'
import { useQuery } from '@supabase-cache-helpers/postgrest-react-query'

export default function Page() {
  const { data, error } = useQuery(getUser())

  return (
    <div className="flex flex-col items-center justify-center">
      <h1>Get User</h1>
      <pre>data: {JSON.stringify(data, null, 2)}</pre>
      <pre>error: {JSON.stringify(error, null, 2)}</pre>
    </div>
  )
}

🧠 Why use it?

✅ Type-safe .select() queries (no more string guessing)

🔁 Works seamlessly with @supabase-cache-helpers/postgrest-react-query

⚡ Perfect for complex nested relations

Would love your feedback or ideas for improvements! 🙌