add custom SQL views to home screen?

[dovinmu]

this is a nicer way of browsing the data:

select citations.hash_id,code,desc,narrative,pdf_customer_name,pdf_customer_addr,pdf_insp_type,pdf_date,pdf_report_date from citations inner join inspections on citations.hash_id = inspections.hash_id

except that

• no facets, sorting by columns, etc. Maybe you're just supposed to do it all via SQL
• no free text search
• hash_id doesn't link to full data

How can we enable all those things on a view like this?