The updated SqlQuery function of .NET 8 is pretty cool. It takes a string but safely interpolates the parameters.

https://learn.microsoft.com/en-us/ef/core/what-is-new/ef-cor...

https://timdeschryver.dev/blog/you-can-now-return-unmapped-t...

"With the new SqlQuery method, you can now write your own SQL queries and map the result to any type that you want.

This is useful for tasks that are not directly related to the day-to-day business of your application. For example, this can be used to import data, migrate data, or to retrieve data from a legacy system."