append .db file with new months information

Right now I have a sql query setup to pull and write a sqlite .db file for use with microsoft powerbi. I’ve since been told by the database administrators to not pull historical data anymore and move up my query to just the current month. If I run the original query and create a .db of everything from 2019 - nov 2024, how could I append this .db file with the new data, assuming each month in knime I move the date to equal the current month?

I have something like a unique account number, company name and report month (mm/dd/yyyy) in this report. If I run this for 12/1/2024, I need only that months data to append itself to the .db file I’ve already pulled of the last 4 years.