Can't have a field with name "order"

[lawik]

Hey

I think it's possible to use reserved SQL keywords as field names and such if properly escaped. Ran into a migration not running due to naming it order.

Figured I'd let you know.

[warmwaffles]

@lawik this has been fixed by @Jcambass in #39 and is now released under 38efd93

[lawik]

Perfect! ✨

[mrdotb]

I got the same issue but you could still inserting map and escaping the key.

  def map(p) do
    %{
      "id" => p.id,
      "name" => p.name,
      "active" => Helpers.cast(p.active),
      # use map format instead of keyword because of order which
      # is a reserved SQL KEYWORD we need to quote it
      "\"order\"" => 0
    }
  end

This patch is broke this code. Anyway it was an error to have column call order.
Thanks for the fix.

[warmwaffles]

Yea I think a column named order isn't that far outside of possibly being used.