Sort field columns in aggregations using "natsort" style

[macneurolab]

A typical aggregation contains:
sort: Field or sort:^Field

It would be very useful to have the option to sort the way php "natsort" does:
file1
file2
file10
file20

Currently the result is:

file1
file10
file2
file20

[splitbrain]

Sorting is done in sqlite, there might be a way to encourage natural sorting though.

[macneurolab]

How would you encourage natural sorting?

[splitbrain]

What I meant is that there might be a way to create the SQL query in a way that tells SQLite to use natsort. Unfortunately it seems that SQLite does not have a builtin natsort mechanism. It may be possible to register PHP's natsort as a SQLite callback, but this may have performance penalties. Needs more investigation.