Explanation on execute() vs all() vs get() vs run()

I am using

prepare()

prepare()

to make prepared statements for Turso (so SQLite), and the docs use

prepare.all()

prepare.all()

for SQLite instead of

prepare.execute()

prepare.execute()

as is used for PostgreSQL and MySQL, why is that?

Same goes for

prepare.get()

prepare.get()

for SQLite instead of

prepare.execute()

prepare.execute()

When do I know when to run those different queries for SQLite?

Thank you!