Opaleye.Sql

Documentation

showSqlForPostgres :: forall columns. Default Unpackspec columns columns => Query columns -> Maybe String

When Nothing is returned it means that the query has no results.

Example type specialization:

showSqlForPostgres :: Query (Column a, Column b) -> Maybe String

Assuming the makeAdaptorAndInstance splice has been run for the product type Foo:

showSqlForPostgres :: Query (Foo (Column a) (Column b) (Column c)) -> Maybe String

showSqlForPostgresUnopt :: forall columns. Default Unpackspec columns columns => Query columns -> Maybe String

showSqlForPostgresExplicit :: Unpackspec columns b -> Query columns -> Maybe String

showSqlForPostgresUnoptExplicit :: Unpackspec columns b -> Query columns -> Maybe String

formatAndShowSQL :: ([PrimExpr], PrimQuery' a, Tag) -> Maybe String