v0.10.0 release

[kvch]

⚡ Highlights

• 🚎 Improve integration with ORMs: new subcommand convert to translate ORM SQL migrations scripts into pgroll migrations
• 🏄 Avoid ACCESS_EXCLUSIVE table lock when adding UNIQUE columns
• 🔓 Avoid ACCESS_EXCLUSIVE table lock when adding volatile DEFAULTs to columns

Thanks to first time contributors 🙏 ❤️ :

• @mcadariu

🔴 Breaking changes

Previously, create_index expected a list of strings in columns:

{
  "name": "10_create_index",
  "operations": [
    {
      "create_index": {
        "table": "employees",
        "columns": ["salary"]
      }
    }
  ]
}

To support advanced index field settings like sort, null, collate and opclass, columns must be a map:

{
  "name": "10_create_index",
  "operations": [
    {
      "create_index": {
        "table": "employees",
        "columns": {
          "salary": {}
        }
      }
    }
  ]
}

See the complete changelog for more details: https://github.com/xataio/pgroll/releases/tag/v0.10.0

[mcadariu]

Thanks for the mention @kvch! Nice work all!