Allow Advanced Query Parser to accept in-line comments

Allowing standard SQL in-line comment syntax in Advanced Queries would be very helpful when reviewing/adjusting complex WHERE clauses. For example

Requests.Type_ID = 5306 /*GCF Concept Note*/ AND Codes.Level1_ID = 5600 /*Target Group = Women*/

makes it immediately clear what the codes refer to. For complex queries involving multiple joins and (NOT) EXISTS (SELECT . . . . having some comments to explain the query logic would be excellent!

  • Justin Finighan
  • May 11 2020
  • Reviewed: Voting Open
  • Attach files