This might help -
https://manual.calibre-ebook.com/virtual_libraries.html
Calibre can be used with separate libraries but for what you described I would recommend using Virtual Libraries.
More info on libraries here -
https://manual.calibre-ebook.com/gui.html#library