Is it possible to return values that are computed from other db columns?

[special-character]

I want to return a column that is the highlighted version of some text. In the SQL select statement it looks like this:

...
ts_headline(title, q) as titleHighlight,
...

Is it possible to represent this in my objectType definition somewhere?

I saw the docs for computed fields but don't want to do a second query to get the highlight based on the title. Is there a way to add a computed field that is returned from the db but not a column?

[special-character]

For posterity, I was able to accomplish this with simple computed fields.

I used the normal column title to put the computed database value into, then I did computed resolvers on title and titleHighlight to accomplish what I needed.

 t.field('title', {
      type: 'String',
      resolve: (item) => {
        // Strip out highlight strings
      },
})

t.field('titleHighlight', {
      type: 'String',
      resolve: (item) => {
        // If their is a highlight string in title, return the title
        // else return empty string
      },
})

And in my SQL select statement:

...
ts_headline(title, q) as title
...