rewrite with db.query

export const getPublicNavbarCategories = () => {
  return db
    .select({
      menuItem: getTableColumns(menuItemTable),
      categories: sql<Category[]>`
        COALESCE(
          json_agg(
            category.*
          ) FILTER (WHERE category.id IS NOT NULL),
          '[]'
        )
      `.as('categories'),
    })
    .from(menuItemTable)
    .rightJoin(
      categoryTable,
      eq(categoryTable.menuItemId, menuItemTable.id),
    )
    .groupBy(menuItemTable.id)
    .orderBy(sql`menu_item."id" IS NULL`, desc(menuItemTable.id));
};

export const getPublicNavbarCategories = () => {
  return db
    .select({
      menuItem: getTableColumns(menuItemTable),
      categories: sql<Category[]>`
        COALESCE(
          json_agg(
            category.*
          ) FILTER (WHERE category.id IS NOT NULL),
          '[]'
        )
      `.as('categories'),
    })
    .from(menuItemTable)
    .rightJoin(
      categoryTable,
      eq(categoryTable.menuItemId, menuItemTable.id),
    )
    .groupBy(menuItemTable.id)
    .orderBy(sql`menu_item."id" IS NULL`, desc(menuItemTable.id));
};