sending query from a C program using sqltools (in visual studio code)

i'm trying to send queries from a C program using the sqltools extension in vs code, which i have already connected to my mysql database on xampp, but i can't find any way to send queries directly from the C program and not from the extension's .sql file.

for example, this is the code on the .sql file

INSERT INTO table_name (colum)
VALUES (some_data);

and I would like to turn it into a C function like this one

void storing_data_function (table, colum, data){
    //puts the data into the colum of the table in my database
}

any idea what should i do? I'm not very good at this stuff so if I made any rookie mistakes I strongly apologize.