ALTER TABLE projects
  ENABLE ELECTRIC;

ELECTRIC ASSIGN 'projects:owner'
  TO projects.owner_id;

ELECTRIC GRANT ALL
  ON projects
  TO 'projects:owner';

ELECTRIC GRANT SELECT
  ON projects
  TO ANYONE;

const shape = await db.projects.sync({
  where: {
    owner_id: auth.user_id
  },
  include: {
    issues: {
      include: {
        comments: {
          include: {
            author: true
          }
        }
      }
    }
  }
});

const MyComponent = () => {
  const db = useElectric()!
  const { results } = useLiveQuery(
    db.projects.liveMany({
      where: {
        status: true
      },
      orderBy: {
        name: 'asc'
      }
    })
  )

  return (
    <List items={results} />
  )
}

const MyComponent = () => {
  const db = useElectric()!
  const { results } = useLiveQuery(
    db.projects.liveMany()
  )

  const add = () => {
    db.projects.create({
      data: {
        id: crypto.randomUUID()
      }
    })
  }

  return (
    <List items={results} add={add} />
  )
}