I have currently a bunch of rosbag2s that have been recorded at 30second intervals. I now want to merge those into one large rosbag2.

I have tried looking at the following resources, but nothing is working the way I imagine:

1) https://stackoverflow.com/questions/80801/how-can-i-merge-many-sqlite-databases/11089277

2) https://github.com/gopherchucks/Database-Merging-SQLite3/blob/master/mergeScript.py

I know that rosbag2 is based on SQLlite, so it seems like this should be simple, but I am having trouble with this simple task. Does someone have any guidance on how to do this?