title: SQL: Detect whether an existing view supports INSERTs or UPDATEs
body: <p>I have an application that allows users to define their own views in SQL and later have the application generate metadata about that view. This is mostly really easy as <code>information_schema.columns</code> tells me what the columns/types the view uses.</p>
  
  <p>However, is there a way to find out whether the view can accept INSERT or UPDATE queries without doing something horrible like parsing the SQL myself or doing a test INSERT and checking for errors/rolling back the transaction?</p>