Is it possible to create Dynamic SQL statements purely in SQLite?
No.
SQLite is designed as a small, embedded database to be accessed from a 'real' programming language. Dynamic SQL is not needed for its intended purposes.