Dynamic SQL

[pisees]

Is there a way to do dynamically construct a query. I see in example parameterized query used in WHERE clause, but for what if I wanted to determine the number of columns in a select clause at runtime?

[dmitry-a-morozov]

The library by design relies on static analysis at compile time. If you need to construct queries dynamically consider either raw ADO.NET or Dapper.