What would you recommend a database with a dynamic set of fields?

Question

Database

Advise, please, a database where it is not necessary to define a set of fields in advance.
Those. data comes from sensors in the form "identifier, parameter: value, parameter: value", the number of such parameters can be one or many. And it is not known at all what parameters can.
In terms of load, there are a lot of records - several million per day.
Then you want to conveniently retrieve data from the database by queries, operating with parameter values, for example "where sensID = '555' and param1 > 123 and param2 < 123 and datetime between ()"
Or is it better to do it somehow differently?

Answer 1

MongoDb is the best for just such purposes.

Answer 2

mysql >=5.7 + json

Answer 3

Here, as it were, one of two things is either fairly rigid regularity in the form of classic tables with hard-declared fields (which makes it possible to build specific hints for searching, selecting, sorting - indexes), or getting some kind of "flexibility", but losing the possibility of regular operations.
In my opinion, the voiced task fits perfectly into the classics of relational structures:
id, parameter serial number, parameter value
or even
id, parameter serial number, parameter type, parameter value,
respectively, then all the goodies of sorting, grouping, aggregating, searching - will be available in all their glory