How to change output format of column value?

[rsktash]

Prisma has result extensions where we can format values, e.g. formatting dates as 'YYYY.MM.DD'
How can we do the same with Zenstack?
The computed field does not fit

[rsktash]

Sample code of Prisma:

prisma.$extends({
    result: {
      user: {
        birth_date: {
          needs: { birth_date: true },
          compute(data) {
            return data.birth_date.toISOString().slice(0, 10);
          },
        },
      },
    }
  })

[ymc9]

V3's computed fields allow you to build arbitrary SQL expressions using Kysely's query builder. I believe you should use something like TO_CHAR(field, 'YYYY.MM.DD')?

eb.fn<string>('to_char', [field, eb.val('YYYY.MM.DD')]).as('formatedDate')