I believe I’ve cracked this issue for use with Raspberry Pi and now have Hassio running on a MicroSD with the sqlite database stored separately on a local USB drive!
For those interested in reproducing the solution I took, please see my longer comment (#25) on Home Assistant community blog post “Save DB on USB stick/drive (Hassio).”
I hope this information helps others!
Ben