Build list for unprepared table/field names, to be improved with WP 6.2's %i placeholder

[leonidasmi]

With WP 6.2, the %i placeholder has been introduced, that can be used for table or field names in queries. Until now, WP developers had to phpcs:ignore those instances because there was no way of dealing with this.

We have a lot of queries where we do that and now we're able to improve our handling of those with the new placeholder. This task is the first step of this.

• Run vendor/bin/phpcs --sniffs=WordPress.DB.PreparedSQL,WordPress.DB.PreparedSQLPlaceholders --ignore-annotations in all Yoast plugins
• Manually review the results and single out the ones that are about unprepared table/field names. An example is this one.
• Create a Google sheet with all those cases

That sheet will later used in order to improve our handling of those unprepared table/field data, as per this.

Tasks

Beta Give feedback

1. Add placeholders for wordpress-seo #20702
   4 of 11
   +0
2. Add placeholder for premium #20703
   +0
   
3. Add placeholders for news #20704
   +0
   
4. Add placeholders for video #20705
   +0
   
5. Add placeholders for local #20706
   +0

[thijsoo]

The doc is: https://docs.google.com/spreadsheets/d/1NmMFdMF7YlxjbuM8-APufjQdX2GxTjbRgN6GBs2Gs4E/edit?usp=sharing