namespace sql = sqlpp::container;

struct sample
{
	int64_t alpha;
	std::string beta;
	bool gamma;
};

int main()
{
	using container = std::vector<sample>;
	container data;

	sql::connection<container> db(data);
	sample tab;

	db.run(insert_into(tab).set(tab.alpha = 17));
	db.run(insert_into(tab).set(tab.beta = "cheesecake"));
	db.run(insert_into(tab).set(tab.alpha = 42, tab.beta = "hello", tab.gamma = true));
	db.run(insert_into(tab).set(tab.gamma = true));

	for (const sample& row: db.run(select(all_of(tab(tab))
	                                 .from(tab)
	                                 .where(tab.alpha < 18)))
	{
		std::cerr << "alpha=" << row.alpha << 
		           ", beta=" << row.beta << 
		           ", gamma=" << row.gamma << std::endl;
	}

	return 0;
}