Visual Query is positioned as a low-code ELT tool, but it lacks the ability to add custom expressions to create new columns—a basic feature present in Power Query. This limits its usability for data professionals who work with large datasets but want to avoid writing full SQL queries for basic transformations.
Custom Column is essential for basic ELT logic (e.g. column math, conditional flags). Its absence forces users to either switch to full SQL or abandon Visual Query.
No CommentsBe the first to comment
