**QueryData Enhancements**
**QueryData Enhancements**

- Add `sqlite_dump` option which uses an in memory sqlite database and
  dumps to a SQL script at the path provided
- Simply defaults for lookups.  Now only a `table` key is required for a
  lookup.  `key_field` is still supported.  `join_field` and
  `value_field` are now ignored
- Simplify handling of 'Id' field.  If the 'Id' field is not specified
  in a mapping, an autoincrementing primary key field is created and
  used as the id for references.  Continues support for prior
  functionality which used the OID as the pk id if fields contains a
  mapping for `Id: sf_id`

    - A new table is created to store primary key id to sf_id
    - The id to sf_id table gets dropped at the end of the task once all
      references are made with the primary key id.  This helps avoid
      conflicting lines in version control caused by different sf_ids on
      retrieve

SalesforceFoundation/CumulusCI,SalesforceFoundation/CumulusCI