improved jdbc manager API, added upsert for left tuples