SPI ram and Nios on FPGA MAX10

The OP is talking about an SPI ram, not an SDRAM. None of the documentation you pointed to is relevant.

As far as I know there isn't any ready available module for what you want to do. If you use a generic SPI master IP, you will have to write a software driver and manually send commands to the RAM and read back the results.

If I understood your post correctly, you'd rather like a hardware module that will make the SPI ram directly available to the Nios II CPU as if it was a regular RAM. I'm afraid you will have to write this yourself.