It has never been possible to delete a device from somewhere else than a device group, for security reasons. Please consider voting for this idea if you want this to be implemented in the future. Also check my comment.
Please also consider voting for this idea if you want to add more SQL Operator options for creating Free Queries in Asset Core in the future.
Have a good day