Anorm is a module in Play that supports interactions with the database using a plain SQL.
Anorm exposes methods to query the SQL database and parse the result as Scala objects, built in as well as custom.
The objective behind Anorm as stated on the Play website (https://www.playframework.com/documentation/2.3.x/ScalaAnorm) is:
Using JDBC is a pain, but we provide a better API
We agree that using the JDBC API directly is tedious, particularly in Java. You have to deal with checked exceptions everywhere and iterate over and over around the ResultSet to transform this raw dataset into your own data structure.
We provide a simpler API for JDBC; using Scala you don't need to bother with exceptions, and transforming data is really easy with a functional ...