rows loaded \pp \dbase\sqldumpdb py testdb ('bob''devel' ('sue''music' ('ann''devel' ('tim''admin' ('kim''devel' in closinghere are three queries in action on this new data setthey fetch names of developersjobs that pay above an amountand records with given pay level sorted by job we could run these at the python interactive promptof coursebut we're getting lot of setup and boilerplate code for free here\pp \dbase\sqlquerydb py testdb "select name from people where job 'devel' records name =bob name =ann name =kim \pp \dbase\sqlquerydb py testdb "select job from people where pay > records job =music job =devel \pp \dbase\sqlquerydb py testdb "select from people where pay > order by job records pay = job =devel name =kim pay = job =music name =sue before we move onsome contextthe scripts in this section illustrate the benefits of code reuseaccomplish their purpose (which was partly demonstrating the sql api)and serve as model for canned database utilities but they are still not as general as they could besupport for sorting options in the dump scriptfor examplemay be sql database interfaces