I think you can go with the SQL query because it is just updating the values for Advanced=NULL or go to admin mode choose the page type there and the property try clicking reset default so both options are good but the second way is recommended way.
I recently renamed a property to a new name. I created a MigrationStep (https://world.episerver.com/documentation/developer-guides/CMS/Content/Refactoring-content-type-classes/) to manage the name change.
The migration went ok, the property is renamed, the data is in there, BUT the GroupName is ignored - the property is now in Content.
It looks exactly the same issue as this: https://world.episerver.com/forum/legacy-forums/Episerver-7-CMS/Thread-Container/2013/7/GroupName-not-getting-updated-from-code/ but it seems it still hasn't been fixed as I am on EPiServer.CMS v11.13.2 and that was about EPiServer 7.
I found the reason is that in tblPropertyDefinition, the MigrationStep set the Advanced property from NULL to 0.
If I change the property to NULL manually (on my local copy of the db) then the content is in the correct tab, the same one the original property was in.
Is there a way to set that Advanced field to null in code without actually going via the DB? Is there something I did wrong?