Book Image

Haskell Cookbook

Book Image

Haskell Cookbook

Overview of this book

Haskell is a purely functional language that has the great ability to develop large and difficult, but easily maintainable software. Haskell Cookbook provides recipes that start by illustrating the principles of functional programming in Haskell, and then gradually build up your expertise in creating industrial-strength programs to accomplish any goal. The book covers topics such as Functors, Applicatives, Monads, and Transformers. You will learn various ways to handle state in your application and explore advanced topics such as Generalized Algebraic Data Types, higher kind types, existential types, and type families. The book will discuss the association of lenses with type classes such as Functor, Foldable, and Traversable to help you manage deep data structures. With the help of the wide selection of examples in this book, you will be able to upgrade your Haskell programming skills and develop scalable software idiomatically.
Table of Contents (13 chapters)

Using Esqueleto to do advanced SQL queries

We have used the Persistent library and SQL expressions using the Database.Persist.SQL module. We have used the generated types for each field in the filter, insert, and update expressions. But the complexity of the query can increase rapidly. Of course, there is a way to do a plain SQL query with the persistent library. Here, in this recipe, we will be using the Esqueleto library to do complex queries such as joins.

In this recipe, we will write a complex SQL query that is type-safe and easy to write. Being type-safe is good, because we will catch any major issues earlier on!

How to do it...

  1. Create a new project called using-esqueleto with a simple stack template:
        stack...