The environment in question is very close to what is described in this thread: http://communities.netapp.com/message/7713#7713. Great information BTW. Any one looking for SQL, SnapDrive and SnapMirror integration is recommended to start there...
Does SnapDrive CLI provide any functionality to create FlexClones from SnapMirror Destination volumes? We can do this using the GUI, however, I can't seem to find a way to do it over a CLI. The key here is to get SnapDrive to do it so that it is host-consistent.
Cheers