Qt: how to execute select SQLite query in QsqlTableModel?

I show all my SQLite database table on the QTableView using QSqlTableModel as follow:

QSqlTableModel *model = new QSqlTableModel(this,db_manager->db);
model->setTable("personal_info");
model->setEditStrategy(QSqlTableModel::OnManualSubmit);
model->select();
ui->tableView->show();

However, I want to select specific columns from my database to show inside the QTableView and not the whole table.

My question is how to execute my select statement ? and where should I put it ?