CB Query Field, insert query?

Is there a way to use CB Query to insert into a database?
I have been using CB Query to pull from a custom table (one to many relationship, multiple rows per user ID) successfully for some time and found it helpful. We have been populating this custom table using MS Access via ODBC connection but it is fairly clunky; I would prefer to use a web based solution to do so. I originally did not go with the comprofiler table due to the multiple records per user (like an educational transcript)

Here is the query I'm currently using in CB Query to pull the desired data and display in a CB Query field: I would like to insert using a similar method:

SELECT `completion_date`,`biennium`
FROM `zzz_mce_completion`
WHERE `user_id` = '[user_id]';

If CB Query (or other CB plugins) are not designed to do this, do you know of any other solutions that would do custom table inserts (I saw Alter reports suggested in one of your other posts)

Is there a way to use CB Query to insert into a database?

Nope, it's for pulling data and not inserting data.

If CB Query (or other CB plugins) are not designed to do this, do you know of any other solutions that would do custom table inserts (I saw Alter reports suggested in one of your other posts)

You could use CB Auto Actions to push data in multiple ways. For example you could use a Query action on the after user update trigger to execute a query when the user updates their profile. The Query action can work with internal and external databases as well. There's also the Code action if you need to use PHP. If you need to make an HTTP request you can use the Request action.