create returns nil for custom primary keys about rom-sql HOT 4 OPEN

I'm working on various improvements in the command API in rom 6.0 that will be reflected in rom-sql 4.0 and so I'll address this issue as part of this work.

from rom-sql.

Test in rom 5.0, when primary key isn't integer it always return nil

from rom-sql.

I use TracePoint to check the values. The return value invalid causes it.

The pks will return [1] when we insert a new record. And the relation.where use the pks to find the data to return. But our primary_key is UUID that cannot match the 1 and we got the empty results.

The tracepoint usage:

trace = TracePoint.new(:return) { |tp| pp [tp, tp.path, tp.method_id]; tp.binding.pry if tp.path.include?('commands/create.rb') }; trace.enable { UserRepository.new.create(name: 'Aotoki') }

Add Sequel::Dataset#returning may help it:
https://www.rubydoc.info/github/jeremyevans/sequel/Sequel%2FDataset:returning

def insert(*args, &block)
  dataset.returning(primary_key).insert(*args, &block).map { |hash| hash[primary_key] }
end

The SQLite version too old will receive RETURNING is not supported on sqlite (Sequel::Error) error

from rom-sql.

I too am having this issue trying to work with a number of tables with non-numeric primary keys. Are there any updates on this? Any workarounds?

from rom-sql.