Since Business Central v21, a new feature has been introduced: the DataTransfer type, which enables for fast moving of data between fields or tables with an insane performance gain over whatever we were able to do before we had this. In short: we’re able to copy the data of an entire table with only one SQL statement.