Issue sorting Tables

[the-dcruz]

Sorting Sources->Tables by Database or SQL Editor returns an exception.

ProgrammingError: (_mysql_exceptions.ProgrammingError) 
(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL 
server version for the right syntax to use near 'desc \n LIMIT 500' at line 2") 
[SQL: u'SELECT `tables`.created_on AS tables_created_on, `tables`.changed_on AS 
tables_changed_on, `tables`.id AS tables_id, `tables`.table_name AS tables_table_name, 
`tables`.main_dttm_col AS tables_main_dttm_col, `tables`.description AS tables_description, 
`tables`.default_endpoint AS tables_default_endpoint, `tables`.database_id AS tables_database_id,
`tables`.is_featured AS tables_is_featured, `tables`.annotation AS tables_annotation, 
`tables`.user_id AS tables_user_id, `tables`.offset AS tables_offset, `tables`.cache_timeout AS 
tables_cache_timeout, `tables`.`schema` AS tables_schema, `tables`.changed_by_fk AS 
tables_changed_by_fk, `tables`.created_by_fk AS tables_created_by_fk \nFROM `tables` ORDER BY 
database desc \n LIMIT %s'] [parameters: (500,)]

[the-dcruz]

Looks like sorting by Database is probably an issue since it is a key word therefore causing the syntax issue.

I just now realized that sorting by SQL Editor actually returns a different error.

OperationalError: (_mysql_exceptions.OperationalError) 
(1054, "Unknown column 'sql_link' in 'order clause'") 
[SQL: u'SELECT `tables`.created_on AS tables_created_on, 
`tables`.changed_on AS tables_changed_on, 
`tables`.id AS tables_id, 
`tables`.table_name AS tables_table_name, 
`tables`.main_dttm_col AS tables_main_dttm_col,
`tables`.description AS tables_description, 
`tables`.default_endpoint AS tables_default_endpoint,
`tables`.database_id AS tables_database_id, 
`tables`.is_featured AS tables_is_featured,
`tables`.user_id AS tables_user_id, `tables`.offset AS tables_offset, 
`tables`.cache_timeout AS tables_cache_timeout, 
`tables`.`schema` AS tables_schema, 
`tables`.changed_by_fk AS tables_changed_by_fk, 
`tables`.created_by_fk AS tables_created_by_fk \n
FROM `tables` ORDER BY sql_link asc \n LIMIT %s'] [parameters: (500,)]

This issue is caused by sql_linkbeing a transient property defined as:

# Snippet from models.py

@property
    def sql_link(self):
        return '<a href="{}">SQL</a>'.format(self.sql_url)

I guess the fix would be to sort by database.id instead or have the column not sortable at all.

[ratb3rt]

Several other sorts affected by the same issue:
Databases: backend, creator
Tables: table, database
Slices: slice, creator
Dashboards: creator