# [轮子]piccolo
- @code
- @doc https://piccolo-orm.com/ (opens new window)
# Select:
await Band.select(
Band.name
).where(
Band.popularity > 100
).run()
# Join:
await Band.select(
Band.name,
Band.manager.name
).run()
# Delete:
await Band.delete().where(
Band.popularity < 1000
).run()
# Update:
await Band.update({Band.popularity: 10000}).where(
Band.name == 'Pythonistas'
).run()