Flowmachine query to_sql permissions error

[jc-harrison]

The to_sql method of flowmachine queries allows for query results to be stored in a specified table outside of the cache schema. However, the executed SQL always includes ALTER TABLE {full_name} OWNER TO flowmachine; so that cache tables can be removed by the flowmachine cache pruner. This can cause an error when using flowmachine as a library, if a user attempts to write a query result to a table in a schema for which they have write access but do not have permission to change ownership.

I think the best solution here would be to alter table ownership only if the table is created in the cache schema - tables created elsewhere are outside the jurisdiction of flowmachine cache management, so there is no need for them to be owned by flowmachine.