How can i define a model that queries from a function?

[nicerobot]

For PostgreSQL

select * from some_function();

[vmihailenco]

You can use a raw query and scan into a struct

type Model struct {...}

dest := new(Model)
db.Raw("select * from some_function()").Scan(ctx, dest)

[nicerobot]

Thanks, @vmihailenco

Is there also a way to use that query as a subquery for other queries (like with a standard model-based query)? I'd like to be able to tell Bun that my raw query adheres to a model so that I can use it like any standard model in Bun.