we actually discuss how we can displace some SQL scripts how we use today (especially for Performance reasons) in BC. To normal answer for this would be Queries (there are a little bit unflexible, but with uses a little bit head we should find solutions for it).

A big disadvantaghe today is that Queries are not expandable in custom apps (select a additional field with group by etc.). So it would be helpful if we have also the opportunity to create Query Extensions!
Category: Development
Needs Votes
Ideas Administrator

Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future.

Best regards,
Business Central Team