1) We generally create a new product or new full version of an existing product once a month. New products are usually $100-$200 with upgrade pricing of about half of that. Subscribers would get any new extension (not solutions).
If you cancel a subscription you can continue to use any extensions you paid for before the subscription but lose access to anything you got as a direct result of the subscription and wouldn't have otherwise.
We will only be offering php mySQL extensions moving forward. New extensions and updates to current ones will not have ASP or Coldfusion support.
Views are supported in mySQL 5+ (which has been out for around 5 years now).
Some tools don't have a button to create a view, but you can always create one with a SQL statement directly like:
CREATE View ViewName AS (SELECT ...)
I think that answers all of your questions. Let me know if you want more clarification.