I've done the POC using plain old SQL statements, but depending on tech stack, we might choose an ORM or something. Not my preference other than Java world