select m1_0.id,m1_0.email,m1_0.name from member m1_0 where m1_0.id=?
select b1_0.id,b1_0.author,b1_0.available_copies,b1_0.isbn,b1_0.title,b1_0.total_copies,b1_0.version from book b1_0 where b1_0.id=?
select l1_0.id from loan l1_0 where l1_0.member_id=? and l1_0.book_id=? and l1_0.returned_on is null fetch first ? rows only
select count(l1_0.id) from loan l1_0 where l1_0.member_id=? and l1_0.returned_on is null
insert into loan (book_id,borrowed_on,due_on,fine,member_id,returned_on,id) values (?,?,?,?,?,?,default)
update book set author=?,available_copies=?,isbn=?,title=?,total_copies=?,version=? where id=? and version=?
