Function getOwners

console/src/api/materialize/expressionBuilders.ts:21–37

()

export { semverParseGte };

export function getOwners() {
  return queryBuilder.selectFrom("mz_roles as r").select((eb) => [
    "r.id",
    "r.name",
    eb
      .or([
        sql<boolean>`(${hasSuperUserPrivileges()})`,
        eb.fn<boolean>("has_role", [
          sql.id("current_user"),
          "r.oid",
          sql.lit("USAGE"),
        ]),
      ])
      .$castTo<boolean>()
      .as("isOwner"),
  ]);
}

// Note(SangJunBak): This is a helper function to convert an expression to a JSON array.
// We need to explicitly type the output and cannot generically use the type of the