One area that still takes a lot of copy/paste or manual typing, is writing SQL. Either for templates of checking stuff on the database interactively. I get repetitively SQL insulted by typing - yet again - the full semantic key in a join of three tables somewhere at the bottom of the data model hierarchy.
Why is that? It is not because the SF does not know which columns I want to join; 97%
+/-3% of the time it is the full key that those tables share. The problem is that I can not tell the SF to write a query skeleton for me without me instructing the SF so via SQL.
What I want to do is:
- select four tables
- click the 'write join clause to clipboard' button
- paste the generated 'select t1.*, t2.*..tn* from t1 join t2 on available keys... tn on available keys' in the SQL editor of choice in the dialect configured for this project.
The tasks could be made available in the data modeller. In that case the join-generator could take in account the references that one highlighted.