Is it possible to combine the features of MODX and the custom functionality of PHP and still work in a single SQL database?

Question

MODX

Good afternoon friends!
Need advice!
After designing and "landing" several sites on MODX, I came to the conclusion that MODX can't do everything. It's certainly "flexible", but it's still not a dynamic site!?
(As far as I understand, dynamic sites are made in PHP?)
And here's the actual situation:
The fact is that when installing MODX, you must specify the SQL database .. Actually, I do this every time - then, I cut the HTML layout into chunks and the site is already managed by MODX.. Bottom line
(1) : Getting a site on the engine MODX + SQL base - But it's still not dynamic!
And on the other hand, I TAKE the same HTML-layout, but with the help of PHP I divide it into functional modules - and with the help of PHP I work with another (so to speak test) MySQL database (I'm afraid to spoil (overwrite somehow) the SQL database on which MODX installed).
Bottom line(2) : I get a dynamic HTML site + PHP + SQL base - But without the MODX engine!
By dynamism, I mean: (display news in a cycle, use man-made PHP functions for various purposes (counters of views, and date and time of publication - which return values ​​to the SQL database))
So the question is:
Is it possible to combine the features of MODX and custom PHP functionality?
And if so, can I use PHP to work on the SQL database that MODX "lives" in? Will the base break from this?
Or is there a way to inject PHP scripts into the MODX engine? (although in fact this is the same question, but on the other hand)
PS I will be grateful for advice and answers

Answer 1

All this can be done on the modx engine, in fact. There is xPDO for working with the database, snippets for custom php code, etc. Although modx is very far from perfect. =)
You just need to understand the engine well and read the documentation, and everything will fall into place...