is there away i can use Scrivener with Ecto.Adapters.SQL.query!(__MODULE__, sql, params)
Scrivener uses Ecto’s query DSL to add the pagination to the query, so no, it is not possible to use it with raw SQL strings.
1 Like
what are the alternative If you have a complex sql
You would have to do the pagination manually by adding a limit and offset to your query or by using a database cursor.
2 Likes
This is exactly what I did ORDER BY r.inserted_at Limit $2 OFFSET $3
1 Like
