Is it possible in SqlKata to somehow select records with the GetAsync?
E.g. I have the public record A(int id) and I have a database table which contains an integer Id column. Now I would like to do something like: query.GetAsync<A>(); to get a collection of elements of type A.
It seems to return an empty collection. While changing the record to class: public class A { int id {get; set;} } seems to work.