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 changese…

Ah! Seeing your result, I maybe see your problem. You’re expected the $1 inside the quotes to get replaced with the argument? Maybe what you actually want is: Ecto.Adapters.SQL.query(Wizex.Repo, "SELECT * FROM game WHERE name ILIKE $1", [name <> "%"])

[image] siddhant3030: But what if I want to write a raw query? How do I do that? The best place to start is always the docs. Hint: it’s a function inside this module Ecto.Repo — Ecto v3.14.0

You might also have a look at… Ecto.Adapters.SQL — Ecto SQL v3.14.0 …for raw queries

Ah yeah, I’m realizing my post wasn’t super helpful because query! isn’t actually in the Repo docs :grimacing:, it’s just added inside repos that actually use SQL adapters. That’s unfortunate.

[image] siddhant3030: Now what I want is to find that user by his email address. FWIW, you can do this with Repo.get_by(User, email: email_to_find).

In case you are exercising raw SQL for learning, you can also directly use the psql command line client for Postgres (assuming that is your database of choice), and directly type SQL in the console.

Can anyone show me some project where sql raw query is being used heavily. Not ecto queries

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 ?

[image] siddhant3030: So should I move my table to SQL Database in order to use raw queries ? 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…

How can I write a raw sql query?

Questions & Help Questions

kokolegorille April 11, 2020, 12:56pm 3

You might also have a look at…

…for raw queries