pinchbv / floor

The typesafe, reactive, and lightweight SQLite abstraction for your Flutter applications
https://pinchbv.github.io/floor/
Apache License 2.0
965 stars 191 forks source link

Feature request: Indexes on Expressions #835

Open ryanheise opened 3 months ago

ryanheise commented 3 months ago

https://www.sqlite.org/expridx.html

Proposed syntax:

@Entity(indices: [
  Index(value: ['y + z']),
])
class Foo {
  @primaryKey
  int x;
  int y;
  int z;

  Foo({
    required this.x,
    required this.y,
    required this.z,
  });
}