Select data from database tables

Hi,
I have a project (more than one actually) where there is certain recurring data. Very structured. I’ll just use one example, a site with book reviews.
In its current un-WP’d state it has a table each for author, genre, review … and other stuff.

Now each “post” would be the review but with a “fact box”, it should also link to the author-post – which should get the data from the appropriate author-table. (Of course multiple books can have the same author etc.) Same for the genre.

It should also be possible to add other data specific to a post to that table row, like ISBN, price and whatever. (Ex: https://www.grimoires.de/zufall.php – left side of the main content above the cover)

Another example with the same principle would be a page about dog breeds. Apart from the text there is also a recurring fact box that shall links to certain other posts like countries of origins or dieases.

Here would be an added (or different) requirement: The dog breeds will have values for weight, height, etc. Ideally there would be a solution where you could easily create a table from this data that can be ordered by min/max-size/weight etc. (Ex: https://www.hudoba.de/hunderassen/bernhardiner/ – the green box at the right).

I would be amazed if there is no solution at all for this out there but am probably using the wrong searches.

Any idea in what direction I may look?