Add custom column to 'GraphQL' select query

[JVariance]

Can I somehow add a column that doesn't exist on the queried table to a 'GraphQL'-style select?

Like:

await supabase
.from('table')
.select(`
  id,
  ...,
  true as exampleBool,
  42 as exampleNum
`);

//Result:
table = {
  id: 1,
  ...,
  exampleBool: true,
  exampleNum: 42
}

[silentworks]

This is not possible, why not just do this in javascript land rather then trying to get it back as part of the results?

[JVariance]

I somehow liked that idea more than looping through the array in js.
But thanks ✌️

[lawrencecchen]

Another solution is to create a postgres view and query that instead. Not particularly relevant for simple cases, but helpful if you want joins, more complicated queries, or to offload work to the database.
https://postgrest.org/en/v7.0.0/api.html

[JVariance]

Thanks, I had Views in mind, but I tried to avoid writing complex joins through nested/foreign keyed tables.

[steve-chavez]

Computed columns look fit for this case. Though they usually "compute" a value based on other columns they can also be used for constants.

CREATE FUNCTION "exampleNum"(my_table) RETURNS int AS $$
  SELECT 42;
$$ LANGUAGE SQL;

await supabase
.from('my_table')
.select(`
  id,
  ...,
  exampleNum
`);

//Result:
table = {
  id: 1,
  ...,
  exampleNum: 42
}