Enhance the SQL Editor
Some features would be good to developers:
1) Tabbed SQL Query Windows - allow user to create a query window without binding to a query object (like we do in SQL Server)
2) Format the query field with highlighting, identation, colors and make possible to even resize the font size. .
3) Allow intellisense to get [table].[field] list (in A2013 we have it in Query Designer but no in SQL mode)
4) Split the window in SQL Query and result pane - and make it possible to see result in table or text format (like we have in SQL Server). So, we can click on "execute/run" and see both panels.
Also allow users to move direct to SQL view from the ribbon rather than first selecting design view
I wish they'd take out the thing that vomits unnecessary parentheses all over my WHERE clauses.
Mark Jaskula commented
Pitty this won't go anywhere. You can always use SSMS to create your queries and then use passthrough SQL queries using something like the following hack:
Dim qdf As DAO.QueryDef
Set qdf = CurrentDb.CreateQueryDef("")
qdf.connect = "ODBC;Database=tsfe;FileDSN=C:\settings\tsfe.dsn;"
qdf.sql = queryStr
qdf.ReturnsRecords = True
qdf.ODBCTimeout = 0
Set SQLOpen = qdf.OpenRecordset
Set qdf = Nothing
We asked numerous times to enhance the SQL editor and they all been shot down. Just not going to happen any time soon, if ever!
Ben Sacheri commented
Save your votes. This has already been set as [NO CURRENT PLAN] in a similar issue.
Complicated queries with multiple outer joins often require sub-queries. While this can be done in the SQL window, it would be nice if there was a way to do this in the designer window.
It would also be nice if you could create SQL Server pass-through queries in the designer window and not just manually in the SQL window (or in code).
Mark Burns commented
this request duplicate the basic point of at least 2-3 other requests already posted.