That's really cool, thanks for sharing! I've also considered using shadow tables but haven't needed them yet. Might change in the future. I really like how your solution allows one to user regular DDL statements and not some DSL.

Let me know if you run into any bugs :)