The dummy table DUAL usage makes sense to me. But I was diving heavily into the docs for DBD::SQLite and SQLite the database yesterday and never saw mention of DUAL. Just to be sure before posting this followup I double-checked the SQLite documentation using a word search for /\bdual\b/i and didn't find any use of that word in SQLite's documentation, at least in the context of a dummy table.

Nevertheless, I'm glad to have learned something new that I can apply to other DB implementations. And to your point, perhaps 'soon' the SQLite author will decide to implement the feature. :)