SQLite can even join data together from multiple different database files, though the Datasette interface doesn't support cross database joins just yet.
Yes, you can load data from different sources into the same database - each of the Dogsheep tools lets you pick the database file that you are importing data into.
I think that there are a lot of use cases if I can join data from different sources of my knowledge base