Not compatible with PostgreSQL?

[Marcuzz]

Hi,

When using this plugin with PostgreSQL we seem to be encountering a lot of errors with several SQL queries. For example:

craft-assetusage/src/console/controllers/DefaultController.php

Lines 71 to 72 in dc6b757

	->where('relations.targetId=assets.id')
	->orWhere('relations.sourceId=assets.id');

The columns in PostgreSQL are transformed to lowercase unless they are wrapped in double quotes, and PostgreSQL is case-sensitive. For these queries to work the column has to be wrapped in double quotes, i.e: relations."targetId"

There is another issue on the following lines as well:

craft-assetusage/src/console/controllers/DefaultController.php

Lines 77 to 78 in dc6b757

	->where("`content` LIKE CONCAT('%asset:', assets.id, ':%')")
	->orWhere("`content` LIKE CONCAT('%\"imageId\": \"', assets.id, '\",%')");

There is a type incompatible comparison here. "LIKE" is only possible on text/strings, but "content" is a jsonb column.

There are more similar PostgreSQL errors, here:

craft-assetusage/src/services/Asset.php

Lines 92 to 93 in dc6b757

	->where(['like', 'content', "asset:{$asset->id}:"])
	->orWhere(['like', 'content', "\"imageId\": \"{$asset->id}\","])

I'm not sure what the best way to fix this is, while keeping compatibility with MySQL as well, so I figured I'd just create an issue as opposed to a PR.