add functional proof of concept for pillow and sql integration

- also a basic test
- pull out doc/indicator pair used in tests so it can be reused