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");
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");