What ability the Plutus on-chain code has? can it read transaction detail including metadata?

[KryptoKing]

I was thinking somthing like this I have a draft on it.
Is this what you would like or do you require something different? I want to know if there is a separate CIP that needs writing.

CIP Draft: Extending Plutus with SQL Transcomplier

Preamble Abstract The current state of the Plutus smart contract DSL limits the range of applications that can be built upon the Cardano blockchain. This is proven by contrasting the capabilities offered by Ethereum to its developers to those Cardano offers us. This CIP is solely concerned with the ability to query the Cardano blockchain from within a Plutus smart contract. The Plutus smart contracts are run on the chain as Plutus-core bytecode; this should allow the contract to query the cha…