For this query

SELECT * FROM `table` ORDER BY `name` ASC LIMIT ? OFFSET ?

What is the reason why it is not supported?

1064 (HY000): Getting syntax error. Detail message: using parameter(?) as limit or offset not supported.

The limit value affects the query planning. Using dynamic value could reduce the performance.