I have any application that uses EF Core. I would like to create a new table that has a column with a raw SQL query string, a second column with a user_Id, and a third column with a report_name. The table would be meant for custom reports from the database.

The idea would be that a user can go to a Custom Reports page(action) and it would have a list of the report_name's that they can click on and it would display the custom report in a table.

I took a look at Dapper however I can't seem to find INNER JOIN examples that are anonymous. I don't want to have to assign a model. Are there other options that I can sue with .Net Core 2? ADO.Net?

I understand the security risks, this is an authenticated app using Okta, with 1 user (myself). I use it for personal planning and learning.