So, Ecto / Phoenix do not support using raw SQL queries natively?
acrolink
dom
LostKobrakai
Phoenix doesn’t as it’s just the webframework, but ecto and it’s db drivers surely do. But besides the ever present few edge-cases it’s questionable why one would use them over ecto queries, which can work with changeset or schemas. With schemaless queries you could even have the safety of ecto types/changesets without needing schemas.
0
kylethebaker
The phoenix generators set you up with ecto by default (unless you pass --no-ecto), but otherwise phoenix doesn’t care about the database/ecto (although Phoenix.Html.Form can use changesets out of the box).
With ecto you can pass raw queries, though it ultimately comes down to the database adapter. You can pass raw sql strings or use the query builder. It’s entirely schema agnostic, though there are a few places that nudge you in a certain direction by providing sensible defaults. In these cases you are always able to override the defaults though.
0