Joe work

Work to put footer annotation in place and JSON<->SQL library.