Add PIE support for native extension

I want to use the native extension with Static PHP, which is used to make static builds of frankenphp.

I had asked the team at Static PHP to consider adding the native parser extension to their static builds, but they felt it was a bit too niche to be appropriate. They also said that there would probably be problems due to the Rust toolchain

https://github.com/crazywhalecc/static-php-cli/issues/1239

They said that it would be ideal if PIE support could be added to the native extension, such that you could just do this

sudo apt install -y php-devel pie-zts
sudo pie-zts install wordpress/extension_name
and you're done. PIE compiles from source, so it'll take a bit, but this seems to be a very small extension so only a few seconds.

Is this something that could be done?

I see one comment in the codebase related to PIE, but I dont know what to make of/do with it.

https://github.com/WordPress/sqlite-database-integration/blob/4cfe40662e504d348561f259e94008ed91607f48/packages/php-ext-wp-mysql-parser/wasm-spike/build-in-docker-rust.sh#L158

Read wasm-spike/build-in-docker-rust.sh around line 158 and inspect how the native extension is currently built. Compare that setup with PIE's expected installation flow, then verify whether PIE can compile and install the extension successfully; done means the documented pie-zts install command works for the extension.