The .Query method expects a sequence of F# record types as its target. When the user does a simple query of say integers it fails saying that (int32) doesn't have that field name. Would be nice if it identified single value arrays of basic types and handled that gracefully.
`
let getCycle rid =
let sql = sprintf "SELECT run.customer_id FROM dtdqc.run as run WHERE id = %s" rid
let cycle_id =
sql
|> conn.Query
|> Array.ofSeq
cycle_id
And when I run it I get this error:
ERROR: name mapping, SQL name 'customer_id' not found in target Record`