can't express order by after insert + returning

[jaredh159]

since sqlite supports this, i was surprised to find i couldn't do this:

try Episode
  .insert { episodes }
  .returning(\.self)
  .order { $0.pubDate.desc() } // 🚨  error: value of type 'Insert<Episode, Episode>' has no member 'order'
  .fetchAll(db)

am i missing something? or just not implemented yet? would you be open to a PR?

[mbrandonw]

Hi @jaredh159, are you sure SQLite supports this? I get an error:

sqlite> insert into foos (id) values (1), (2) returning * order by id desc;
Parse error: near "order": syntax error
  insert into foos (id) values (1), (2) returning * order by id desc;
                                      error here ---^
sqlite> select sqlite_version();
3.43.2

And from the flow chart of RETURNING it does not seem like orders are possible:

I think rows are just returned in an unspecified order.

[jaredh159]

shoot, truly sorry to waste your time here. both Claude and ChatGPT told me this was supported 🤦‍♂️

definitely aware that LLMs hallucinate stuff, but when it comes to sqlite, they seem super reliable.