Update: This enhancement is now on trunk and will be included in the 3.50.0 release of SQLite due out in about four weeks.