mssql static dynamic select

The TNG database layer has the concept of static and dynamic queries. Insert, update, delete, and merge queries must be dynamic, which is great because it provides an abstraction from writing SQL statements, allowing the layer to create the proper SQL that goes to the database engine. However, the database abstraction layer for Drupal 7 allows select statements to be dynamic or static.

I'm writing a book on Drupal 7 for Windows developers, and I see a potential problem with allowing people to write static queries. That is, they may not be transportable across different engines.