Custom DB-Tables with selectable output

Hi,

I have for a while been looking for something that I just cannot find but am sure must exist somewhere. (Maybe I use the wrong keywords.) What is that, you may ask? And without further prelude I shall answer:

A Custom Database-Table whose contents can easily be loaded into wordpress. This could be a shortcode or via a selected template. It does need the ability to select from any row and to place the different fields of that row more or less manually. (Basically: Ability to perform standard MySQL-queries and place their results freely)

I need that for a site that provides data about various entities that are rated in some common dimensions, like size and weights. Currently it is all text in a wp standard post. I’d like to provide tables ordered by, for example, size and weight. Bonus points if I can sort for text strings in another field (probably requiring database normalisation and another connecting table [joined], e. g. one dog breed that is suitable for different sports, that are written out [and linked to]).

The classical case where a database would be way more useful if only to be able to provide ordered tables by whatever dimension (column) is deemed worthwhile. (Sortability by a single column as in some review plugins is not sufficient.)

As said, I am sure there is something out there and outside wordpress I have coded this from scratch myself, which is not an option here.

So what keyword am I missing; what plugin do I keep overlooking?

Regards,
Nico

P.S.: In case you’d like a conrete example: http://magazin.mydog365.de/hunderasse/gesellschaftshunde/pekingese/
compare with
http://magazin.mydog365.de/hunderasse/gesellschaftshunde/englische-bulldogge/

As you see, there is quite a bit of recurring data especially in the fact box.