haskell - Yesod Database Query -

i'm new both yesod , databases please bear me basic question:

i plan write sql procedures , store them in .sql files , yesod web application calls these sql file instead of writing queries directly in haskell.

is common practice?

i assume writing queries in sql more suitable writing them in haskell.

any comments welcome.

is common practice?

no. closest can use rawsql in persistent or use other low level library. recommend avoid writing raw sql query unless have valid reason to.

i assume writing queries in sql more suitable writing them in haskell.

no, whole point of using persistent bring type safety database queries. if gonna write them in sql lose benefit.