The queryResults and queryStmtResults functions return a list of values in the QueryResults typeclass. This class performs automatic extraction and type conversion of rows from a query result.

Here is a simple example of how to extract results:

import qualified Data.Text as Text
import Database.MySQL.Nem
import qualified System.IO.Streams as Streams

xs <- queryResults conn "select name,age from users"
Streams.mapM_
   \(name,age) ->
      putStrLn $ Text.unpack name ++ " is " ++ show (age :: Int)
   xs

Notice two important details about this code:

• The number of columns we ask for in the query template must exactly match the number of elements we specify in a row of the result tuple. If they do not match, a ResultError exception will be thrown.
• Sometimes, the compiler needs our help in specifying types. It can infer that name must be a Text, due to our use of the unpack function. However, we have to tell it the type of age, as it has no other information to determine the exact type.

For converting to your custom data types. Check the documentation for the QueryResults package.