I want to insert a table into a database. Looking at the documentation, the easiest think seems to be to build a vector of tuples and then insert it into the database.
However, some of the values might be unknown, so I wonder if there is a way to represent this using this approach. In other words, can I use vector of tuples to insert NULL values in the database? (One natural candidate would be boost::optional, but I have not seen it mentioned anywhere?)
And if there is no natural way of doing this using tuples, can one do it using the "complex data type mapping" mentioned in the POCO Data user guide?