Map/transform selected column

Is it possible to transform a column value when we define the select? This would be super useful for when sharing a subquery as I could cololcate the transform code with it instead of having a seperate transform function. Something like:

db.select(
  isDeleted: item.deletedAt.map(date => date !== null)
).from(item);

db.select(
  isDeleted: item.deletedAt.map(date => date !== null)
).from(item);

db.select(
  isDeleted: item.deletedAt.map(date => date !== null)
).from(item);

db.select(
  isDeleted: item.deletedAt.map(date => date !== null)
).from(item);

Map/transform selected column

Similar Threads

Similar Threads

Similar Threads