How can i show the result of a sqlite query on a dashboard?

Configuration
1

Hello folks,

I am a newbie in Home-Assistant and request your assistance:

I have imported a table with booking information such as arrival date, departure date, guest name, etc. into the HA-SQLite database. Each field is displayed in its own column.

Now I want to show on a dashboard all the bookings coming in the next 14 days with additional information in text format like markdown cart.

I tried the SQL sensor, but it only delivers the first result of the query.

I’m happy about any help.

Thanks in advance

Karl