# Call SQL function when dumping custom Ecto type with SQLite and virtual table

**URL:** <https://forum.elixirforum.com/t/call-sql-function-when-dumping-custom-ecto-type-with-sqlite-and-virtual-table/67935>\
**Category:** Questions\
**Tags:** ecto, sqlite3, custom-type, ecto\_sqlite3\
**Created:** [December 6, 2024, 10:30pm UTC](https://forum.elixirforum.com/t/call-sql-function-when-dumping-custom-ecto-type-with-sqlite-and-virtual-table/67935 "2024-12-06T22:30:26Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![rhcarvalho](https://forum.elixirforum.com/user_avatar/forum.elixirforum.com/rhcarvalho/32/32243_2.png) [@rhcarvalho](https://forum.elixirforum.com/u/rhcarvalho)\
**Post date:** [January 11, 2025, 9:43pm UTC](https://forum.elixirforum.com/t/call-sql-function-when-dumping-custom-ecto-type-with-sqlite-and-virtual-table/67935/2 "2025-01-11T21:43:31Z")

</div>

I’m not sure it would work in this context, but have you considered using Ecto’s `fragment/1`?

> **[Ecto.Query.API — Ecto v3.14.0](https://ecto.hexdocs.pm/Ecto.Query.API.html)**

---

_[View the full topic](https://forum.elixirforum.com/t/call-sql-function-when-dumping-custom-ecto-type-with-sqlite-and-virtual-table/67935)._