PostgreSQL array parameters

This feature is available in PostgreSQL extensions package: DbFun.MsSql.

To make it work, implement configuration with DbFun.Npgsql.Builders package instead of DbFun.Core.Builders and modify config object to support arrays:

let config = QueryConfig.Default(createConnection).UsePostgresArrays()

Then, just define function with an array parameter:

let getPostsByIds = query.Sql<int array, Post list>(
    "select p.postid, .blogId, p.name, p.title, p.content, 
            p.author, p.createdAt, p.modifiedAt, p.modifiedBy, p.status
     from post p join unnest(@ids) ids on p.postid = ids",
    "ids")