siddhant3030
Hi,
I have to write a raw query for one of my project. But till now I have used ecto queries and don’t have much experience writing raw queries in phoenix. So to understand
I have created a user schema that inserts an email in a database table.
So created the changeset the like this
def changeset(user, attrs) do
user
|> cast(attrs, [:email, :password])
end
Now I have a create function that I’m using in my model. So the model will basically talk to db.
def create_user(attrs \\ %{}) do
%User{}
|> User.changeset(attrs)
|> Repo.insert()
end
I have inserted an email in my database. using this
iex(1) > user = User.changeset(%User{}, %{email: “”, password: “”})
Now what I want is to find that user by his email address.
Also If I wanted to fetch through id. I would just do this
def get_user!(id), do: Repo.get!(User, id)
But what if I want to write a raw query? How do I do that?
Where Next?
Trending in Questions
Other Trending Topics
Latest Phoenix Threads
Latest on Elixir Forum
Sponsor Spotlight
Deploy Phoenix to your own VPS with PaaS ease: push-to-deploy, zero downtime, auto SSL, managed Postgres. 14-day free trial at potions.io
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #ai
- #elixirconf-us
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #elixirconf-eu
- #api
- #forms
- #metaprogramming
- #hex
Our Sponsors
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Master modern tools, write cleaner code, and tackle real-world challenges.
Bringing learning, work and compliance together since 1987.
**Building the future of software with AI, trust, and human connection.**
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 1 to 10- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
benwilson512
The best place to start is always the docs. Hint: it’s a function inside this module Ecto.Repo — Ecto v3.14.0
kokolegorille
You might also have a look at…
…for raw queries
benwilson512
Ah yeah, I’m realizing my post wasn’t super helpful because
, it’s just added inside repos that actually use SQL adapters. That’s unfortunate.
query!isn’t actually in the Repo docssiddhant3030
Thanks. This is helpful
al2o3cr
FWIW, you can do this with
Repo.get_by(User, email: email_to_find).lucaong
In case you are exercising raw SQL for learning, you can also directly use the
psqlcommand line client for Postgres (assuming that is your database of choice), and directly type SQL in the console.siddhant3030
Thanks
siddhant3030
Can anyone show me some project where sql raw
query is being used heavily. Not ecto queries
siddhant3030
Hi @kokolegorille
I’m confused about this. Because the database I’m querying is in postgres. But I want to write a raw sql query. Now phoenix comes with Postgres by default. So should I move my table to SQL Database in order to use raw queries ?
sribe
That makes no sense–if your table is not in a SQL database you can’t query with raw queries. I suspect you mean something else, but I can’t figure out what you’re asking…