Support for fragments in {table, schema} tuple

[Benjamin Milde]

Working with sqlite I created a schema for `pragma_table_info(?)`. But in a query I can either use `fragment("pragma_table_info(?)", table_name)` or `{"pragma_table_info('hardcoded_table_name')", Schema}`. I'm wondering if there could be an API to make an arbitrary source in a query be mapped to a given schema.

[benjamin...@gmail.com]

From the top of my head, I think leveraging the https://hexdocs.pm/elixir/Collectable.html and https://hexdocs.pm/elixir/Enumerable.html with https://github.com/elixir-dbvisor/sql might be able to solve this elegantly.

You could use the enumerable example in the readme and implement a collectable for your schema to map the result, or convert the column from string to atom and leverage struct/2.