Could I suggest a little alteration to GT::SQL.

Currently with the select_options method, if you happen to pass in an ORDER clause after a LIMIT clause the query will fail as it expects the LIMIT last. Would it be possible to get GT::SQL to automatically handle this?

eg...

my $table = $DB->table('Links');

# Works
$table->select_option("ORDER BY ID ASC", "LIMIT 20");

# Fails
$table->select_option("LIMIT 20", "ORDER BY ID ASC");