I'm not sure where to start cause knex docs only show how to insert object data with the same column name and key cases. The problem is I have this example database table:
CREATE TABLE IF NOT EXISTS student_info (
id SERIAL PRIMARY KEY,
full_name varchar(32),
);
and I have this example JSON to be inserted into that table:
[
{
id: 1,
name: 'John Doe'
},
{
id: 2,
name: 'Lita Wong'
}
]
There's a problem where full_name column and name key have different name. How can I insert that JSON data into my table without changing my key? I wish there's some way to set an alias or something, but I can't find it anywhere in docs.