How to convert following Ecto Query into the Plain RAW SQL %Workspace{name: "#{prefix() || "public"}"} |> Repo.insert() Your response will be highly appreicable.

regarding docs : Ecto.Adapters.SQL.to_sql(:insert, Repo, %Workspace{name: "#{prefix() || "public"}"}) UPD sorry - :insert is not supported (

MyApp.Repo.to_sql works as well.

[image] LostKobrakai: MyApp.Repo.to_sql works as well. In Ecto 3.0 there are no to_sql callback on repo

Did you try it? It’s documented here: ecto_sql/lib/ecto/adapters/sql.ex at 2ec71d74655cc076b6c965740a357dfe1505883a · elixir-ecto/ecto_sql · GitHub and here’s the macro, which adds it to the repo: ecto_sql/lib/ecto/adapters/sql.ex at 2ec71d74655cc076b6c965740a357dfe1505883a · elixir-ecto/ecto_sql ·…

I want to query something like following execute""" insert into workspaces ( name ) values("#{prefix() || "public"}"); """ becuase I don’t want to use the schema in the command.

[image] ycv005: I want to query something like following In this case use query

What are you trying to do exactly. Because I have strange feeling that we are dealing with XY problem .

It looks like you want to convert an ecto query to an sql query to use in migrations (hence the execute). The problem here is that ecto actually cannot do that completely. Ecto as well as the underlying postgrex adapter does never interpolate parameters into the query. This is left to the database t…

Do you mind sharing any pointers on how exactly Postgres does that interpolation for us? I just badly need a full plain SQL from a (complex) Ecto Query for performance analysis.

[image] mxgrn: Do you mind sharing any pointers on how exactly Postgres does that interpolation for us? I don’t know what exactly happens behind the scenes, but I doubt the db does actually interpolate values: [image] INSERT - PREPARE PREPARE PREPARE — prepare a statement for exec…

Elixir Programming Language Forum

Ecto query into Plain SQL

Questions & Help Questions

waseigo January 14, 2025, 6:20pm 13

Thanks for sharing, very useful!