How do I return only selected fields from the model and its relation

Questions and Answers
13

If anyone would like to find a record that returns only certain columns and no population, try
Bookshelf ORM:

const author = await strapi.query('post').model.forge({ id: ctx.params.id}).fetch({
      columns: ['id', 'title', 'author'],
      withRelated: []});

Without withRelated:[] option strapi will populate automatically, that in many usecases you would not like to.