New page types

[mcrascal]

This will definitely need to be broken down further.

With frontmatter and standalone SQL in place, there are three new "standalone" page types we'd like to build. Each of these would be a "full page" experience, powered by WASM duck db.

There are two goals beyond the value of the features themselves. I think we can achieve these by tackling any one of the proposed page types:

1. Bring WASM ddb into the product. We have big plans here, and want to gain experience without touching the entire core product
2. Set up the infrastructure for new page types beyond the core markdown report

Page types

1. A full page pivot experience
2. A full page sql console
3. A full page record search

Indicating the page type in frontmatter
Each page would map to a single data source.

type: records | pivot | console | page [default] 
sources: ... 

Treatment of markdown body

Initially, markdown body could be ignored.

Eventually, you could see markdown body being included in a slide-over or similar to serve as end user documentation, or similar.

**Where to start **
I think the console is the easiest starting place, the pivot experience is the most valuable, and the record view is the most complex.

super rough drawings for reference