FEATURE or QUESTION: how can I write some calculated column?

[cybermerlin]

What are you doing?

Hi, I need help with this:

select
    birthday, sex,
    concat( lastname, '  ', firstname) as name
from person
where
    name like '%pupi%'

but I try use sequelize like a big trueman:

class Person {
    @Column({type: 'text'})
    firstname;
    @Column({type: 'text'})
    lastname;
    @Column({type: 'datetime'})
    birthday;
    @Column({type: 'tinyint'})
    sex = 1;

    //                           what need I write to do this?
    name;
}

let persona = new Person();
persona.find({name: 'pupi', limit: 1});

console.info(persona.name);

Dialect: any
Dialect version: XXX
Database version: XXX
Sequelize version: XXX
Tested with latest release: No (If yes, specify that version)

[sushantdhiman]

http://docs.sequelizejs.com/variable/index.html#static-variable-DataTypes

You can use VIRTUAL where you can combine two or more fields data, but you have to define those fields which are used in calculation.

But you cant query using VIRTUAL fields, they are unknown to database.