How to connect to SQlite database on Android emulator

sqlite-android-emulator.txt

adb devices
sudo adb -s emulator-xxx shell
run-as {package-name}
cd databases/
ls
sqlite3 {database name}

.databses -> view databases
.tables -> view tables
.schema -> view schema of table
.quit -> quit sqlite

Example query:
Select * from purchases where customer = 'Niels Masdorp';