CREATE TABLE shelf (
 bookid sequence,
 title character varying(200),
 author character varying(200),
 publisher character varying(200),
 isbn character varying(200),
 genre character varying(200)
);

QSqlQuery que;
que.exec("insert into shelf(title) values('blah') returning bookid;");